创建分区表
create table hr.pdba (owner,object_name, created) partition by range (created)
(partition p1 values less than (to_date(‘2018-11-25’, ‘yyyy-mm-dd’)),
partition p2 values less than (to_date(‘2018-12-1’, ‘yyyy-mm-dd’)),
partition p3 values less than (to_date(‘2018-12-3’, ‘yyyy-mm-dd’)),
partition p4 values less than (maxvalue))
as select owner,object_name,created from dba_objects;
导出:
$ exp hr/oracle tables=pdba:p4 file=partition_p4.dmp log=partition_p4.log
$ Expdp system/system DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=PDBA:P4 logfile=exp_p4.log
导入:
$ imp system/oracle tables=pdba:p4 file=pdba.dmp ignore=y fromuser=hr touser=sh
impdp system/system DIRECTORY=dump DUMPFILE=partition_p4.dmp TABLES=PDBA:P4logfile=imp_p4.log table_exists_action=append