[oracle] expdp 导出分区表的分区

来源：这里教程网时间：2026-03-03 16:23:16 作者：

1.查看分区表分区字段

select * from dba_part_key_columns where name='LOAN_UN_APP_INFO_CLOB' and owner ='OLS'; OWNER NAME OBJECT_TYPE COLUMN_NAME -------------------- ------------------------------ -------------------- OLS LOAN_UN_APP_INFO_CLOB TABLE OLS_DATA_DATE

2.查看分区信息

select PARTITION_NAME,HIGH_VALUE from dba_tab_partitions where TABLE_OWNER = 'OLS' and TABLE_NAME = 'LOAN_UN_APP_INFO_CLOB' ;PARTITION_NAME HIGH_VALUE -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- P1_LUAICLOB_01 TO_DATE(' 2020-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') SYS_P14044 TO_DATE(' 2021-01-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') SYS_P14082 TO_DATE(' 2021-01-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') SYS_P14119 TO_DATE(' 2021-01-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') 省略

3.导出分区

可以采用query方式，也可以导出具体分区，本次采用导出具体分区select TABLE_OWNER||'.'||TABLE_NAME||':'||PARTITION_NAME from dba_tab_partitions where TABLE_OWNER = 'OLS' and TABLE_NAME = 'LOAN_UN_APP_INFO_CLOB'; OLS.LOAN_UN_APP_INFO_CLOB:P1_LUAICLOB_01OLS.LOAN_UN_APP_INFO_CLOB:SYS_P14044 OLS.LOAN_UN_APP_INFO_CLOB:SYS_P14082 OLS.LOAN_UN_APP_INFO_CLOB:SYS_P14119省略 nohup expdp \" / as sysdba \" dumpfile=ols_LOAN_UN_APP_INFO_CLOB_BAK20210108.dmp directory=yearend logfile=ols_LOAN_UN_APP_INFO_CLOB_BAK20210108.log logtime=all cluster=no COMPRESSION=all tables=OLS.LOAN_UN_APP_INFO_CLOB:SYS_P14044 exclude=statistics,index & nohup expdp \" / as sysdba \" dumpfile=ols_LOAN_UN_APP_INFO_CLOB_BAK20210109.dmp directory=yearend logfile=ols_LOAN_UN_APP_INFO_CLOB_BAK20210109.log logtime=all cluster=no COMPRESSION=all tables=OLS.LOAN_UN_APP_INFO_CLOB:SYS_P14082 exclude=statistics,index & 省略