可以利用rowid切片方式导出
导出：
vi tableid.par
userid='/ as sysdba'
directory=dir_expdp
content=data_only
compression=data_only
tables=user.tableid
nohup expdp parfile=tableid.par dumpfile=tableid_01.dmp logfile=tableid_01.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=0\" &
nohup expdp parfile=tableid.par dumpfile=tableid_02.dmp logfile=tableid_02.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=1\" &
nohup expdp parfile=tableid.par dumpfile=tableid_03.dmp logfile=tableid_03.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=2\" &
nohup expdp parfile=tableid.par dumpfile=tableid_04.dmp logfile=tableid_04.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=3\" &
nohup expdp parfile=tableid.par dumpfile=tableid_05.dmp logfile=tableid_05.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=4\" &
nohup expdp parfile=tableid.par dumpfile=tableid_06.dmp logfile=tableid_06.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=5\" &
nohup expdp parfile=tableid.par dumpfile=tableid_07.dmp logfile=tableid_07.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=6\" &
nohup expdp parfile=tableid.par dumpfile=tableid_08.dmp logfile=tableid_08.log query=\"where mod\(dbms_rowid.rowid_block_number\(rowid\),8\)=7\" &
导入：
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_01.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_01.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_02.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_02.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_03.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_03.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_04.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_04.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_05.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_05.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_06.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_06.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_07.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_07.log TABLE_EXISTS_ACTION=append &
nohup impdp userid=\"/ as sysdba\" DIRECTORY=dir_impdp DUMPFILE=tableid_08.dmp remap_schema=user:userDB LOGFILE = IMP_tableid_08.log TABLE_EXISTS_ACTION=append &
