Oracle匯入匯出dmp檔案

標籤：oracle dmp expdp impdp

1. create oracle目錄,用user 登入sqlplus

   create or replace directory dpdata1 as ‘/A/B‘;

2. 給予許可權, dba登入sqlplus

   grant read,write on directory dpdata1 to user;
   

3. 匯出dmp

   a.按表匯出,bin目錄下
   

   ./expdp user/[email protected] TABLES=table1,table2 dumpfile=expdp.dmp DIRECTORY=dpdata1;

   b.按使用者匯出

   ./expdp user/[email protected] schemas=user dumpfile=expdp.dmp DIRECTORY=dpdata1;
   

4. 匯入dmp

   a.匯入按表匯出的dmp，bin目錄下

   ./impdp user/[email protected] DIRECTORY=dpdata1 DUMPFILE=expdp.dmp full=y logfile=impdlog.log ;

   b.匯入按使用者匯出的dmp

./impdp user/[email protected] DIRECTORY=dpdata1 DUMPFILE=expdp.dmp SCHEMAS=user logfile=impdlog.log ;

Oracle匯入匯出dmp檔案