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
文章標籤
全站熱搜
