[EXP/IMP]
导出分区:
exp iscs/naritech_zhjkb tables=di_change_event:P4,di_change_event:P5 file=d:/partition_p4.dmp log=d:/partition_p4.log
使用imp工具生成创建分区表的DDL语句:
imp iscs/naritech_zhjkb tables=di_change_event indexfile=D:/table.sql file=d:/partition.dmp ignore=y
导入分区数据:
imp iscs/naritech_zhjkb tables=di_change_event:P4,di_change_event:P5 file=d:/partition_p4.dmp ignore=y
清空分区:
alter table di_change_event truncate partition p4;
[EXPDP/IMPDP]
导出分区:
Expdp iscs/naritech_zhjkb DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=di_change_event:P4,di_change_event:P5 logfile=exp_p4.log;
导入分区数据:
impdp iscs/naritech_zhjkb DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=di_change_event:P4di_change_event:P5 logfile=imp_p4.log table_exists_action=replace
导出分区:
exp iscs/naritech_zhjkb tables=di_change_event:P4,di_change_event:P5 file=d:/partition_p4.dmp log=d:/partition_p4.log
使用imp工具生成创建分区表的DDL语句:
imp iscs/naritech_zhjkb tables=di_change_event indexfile=D:/table.sql file=d:/partition.dmp ignore=y
导入分区数据:
imp iscs/naritech_zhjkb tables=di_change_event:P4,di_change_event:P5 file=d:/partition_p4.dmp ignore=y
清空分区:
alter table di_change_event truncate partition p4;
[EXPDP/IMPDP]
导出分区:
Expdp iscs/naritech_zhjkb DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=di_change_event:P4,di_change_event:P5 logfile=exp_p4.log;
导入分区数据:
impdp iscs/naritech_zhjkb DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=di_change_event:P4di_change_event:P5 logfile=imp_p4.log table_exists_action=replace