关联用户导入:imp system/system@FZCZP file=D:\fzczp.dmp fromuser=(opcard,platform,emsetl,equip,D5000) ignore=y。
关联表导入:imp opcard/opcard@newjxczp file=D:\xx.dmp fromuser=(opcard) touser= (opcard) tables=(t_a_cardwordzb) ignore=y。
imp system/system@CREDIT file=D:\credit3d20170107.dmp fromuser=(credit3d) touser=(credit3d) tables=(credit_infomanager) tablespaces=users ignore=y
关联用户导出:exp opcard/opcard@newjxczp owner=(opcard,platform,emsetl,equip,D5000) file=D:\newjxczp.dmp
分区片段无记录,是导不出来的,处理如下:
查询表分区名:select partition_name from user_tab_partitions where table_name=‘表名’;
查询表分区记录数:select t.partition_name,t.num_rows from user_tab_partitions t where table_name=‘表名’;
select * from user_tab_partitions where table_name=‘表名’; segment分区片段为YES
带上分区导:exp username/password@IP:端口/库名 grants=y file=D:\XXX.dmp tables=(表名:分区1,表名:分区2,表名:分区3,表名:分区4)