As I tried to import dump file, I got the following error:
C:\Users\user01\Desktop λ impdp test_user/oracle@orcl directory=C:\Users\user01\Desktop dumpfile=data.dmp; 連線至: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39002: 無效的作業 ORA-39070: 無法開啟日誌檔. ORA-39087: 目錄名稱 C:\USERS\USER01\DESKTOP 無效
How-To
We need to create directory firstly, then execute impdp command:
CREATE OR REPLACE DIRECTORY DATA_DUMP_DIR AS 'C:\data'; impdp test_user/oracle@orcl directory=DATA_DUMP_DIR dumpfile=data.dmp LOGFILE=dump.log;
No comments:
Post a Comment