1,源数据库执行导出
alter session set container=DXGTKJGH;
select tablespace_name from dba_tablespaces;
表空间信息:DXGTKJGH
创建导出目录:
create or replace directory dmp as '/home/oracle/dump';
expdp system/Oracle_123@10.41.1.233/DXGTKJGH dumpfile=DXGTKJGH.dmp directory=dmp SCHEMAS=DXGTKJGH
2,目标数据库执行导入
alter session set container=KYQGL;
select tablespace_name from dba_tablespaces;
表空间信息:KYQGL
create or replace directory dmp as '/home/oracle/dump';
新表空间:KYQGL 用户信息:KYQGL
impdp system/Oracle_123@10.41.1.233/KYQGL dumpfile=DXGTKJGH.dmp directory=dmp REMAP_SCHEMA=DXGTKJGH:KYQGL remap_tablespace=DXGTKJGH:KYQGL