1、创建目录
mkdir /tmp/dump@H_502_2@

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@H_502_2@

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@H_502_2@

3、导入数据
sqlplus / as sysdba
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;
exit@H_502_2@

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

注意：如果使用select from t_trippay_info查询不到数据，请使用select from "t_trippay_info"查询;@H_502_2@