EXPDP IMPDP 導入導出資料

1、建立目錄

mkdir /tmp/dump

2、導出資料

sqlplus / as sysdba

create or replace directory dump_dir as '/home/oracle/oracleDump';

grant read,write on directory dump_dir to BBGO,BBGPS;

exit

expdp "'/ as sysdba'" schemas=BBGO dumpfile=BBGO.dmp DIRECTORY=dump_dir logfile=expsh.log

expdp "'/ as sysdba'" schemas=BBGPS dumpfile=BBGPS.dmp DIRECTORY=dump_dir logfile=expsh.log

3、導入資料

create user BBGOA identified by BBGOA ;

grant connect,resource to BBGOA ;

create directory dump_dir as '/home/oracle/oracleDump';

grant read,write on directory dump_dir to BBGOA;

impdp "'/ as sysdba'" directory=dump_dir dumpfile=expdp.dmp schemas=BBGO remap_schema=BBGO:BBGOA

注意：如果使用select from t_trippay_info查詢不到資料，請使用select from "t_trippay_info"查詢;

     本文轉自1321385590 51CTO部落格，原文連結：http://blog.51cto.com/linux10000/2059108，如需轉載請自行聯系原作者