Oracle分区表迁移

exp userid=@ parfile=''
--
grants=n
indexes=n
triggers=n
constraints=y
STATISTICS=NONE
LOG=exp.log
tables=
query="where 1=0"

--Import to target database
Login
imp @ file=xxx.dmp tables=''

create directory ext_data AS '/home/oracle/data';
expdp userid=sh@orcl parfile=test1.par

directory=ext_data
EXCLUDE=INDEX,GRANT,TRIGGER,STATISTICS
LOGFILE=test1.log
tables=test1
dumpfile=test1.dmp
query="where 1=0"

impdp sh@orcl parfile=test2_imp.par

directory=ext_data
REMAP_TABLESPACE=sh_data:USERS,sh_data_1:USERS
REMAP_SCHEMA=SH:SCOTT
tables=test2
dumpfile=test2.dmp

相关阅读：