Total Pageviews

2020/06/08

[Oracle] How to import dump file

Problem
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: