Problem:
Oracle Data Pump Import Data encounters ORA-31684: Object type USER:"TESTUSER" already exists


Solution:
Add "exclude=user" within the impdp command

For example:

read -s mypwd
impdp TESTDBA/$mypwd@TESTDB directory=TEST_DIR schemas=TESTUSER2 dumpfile=TESTUSER2_full_exp.dmp logfile=TESTUSER_imp.log remap_schema=TESTUSER2:TESTUSER exclude=user

arrow
arrow
    全站熱搜

    DanBrother 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄