自动分区的表不支持exp备份

查看exp备份日志发现最后一段内容为：

566        MON_TE        MON_TE_202410        DB
Begin Executing:rm -rf DB.MON_TE_MON_TE_202410.pipe
Begin Executing:rm -rf DB.MON_TE_MON_TE_202410.dmp.Z
Begin Executing:mknod DB.MON_TE_MON_TE_202410.pipe p
Begin Executing:compress <DB.MON_TE_MON_TE_202410.pipe> DB.MON_TE_MON_TE_202410.dmp.Z &
Error on export table/partition DB.MON_TE:MON_TE_202410 !Program terminated!
Error on backup partitioned table!Program terminated!

提示有一张表备份出现问题，进程终止。首先去库里查看这张表的具体情况

Show tables matching condition "%DB.MON_TE%" (if schema is not specified then current user's tables only are shown)...

OWNER                TABLE_NAME                     TYPE     NUM_ROWS        BLOCKS     EMPTY AVGSPC ROWLEN TAB_LAST_ANALYZED   DEGREE               COMPRESSION
-------------------- ------------------------------ ---- ------------ ------------- --------- ------ ------ ------------------- -------------------- ----------------
DB               MON_TE             PTAB                                                                                 1

查看这张表的分区情况

TABLE_OWNER                    TABLE_NAME                            POS COMPOS PARTITION_NAME                   NUM_ROWS SUBPARTITION_COUNT HIGH_VALUE_RAW                                                                                       HIGH_VALUE_LENGTH COMPRESSION      COMPRESS_FOR
------------------------------ ------------------------------ ---------- ------ ------------------------------ ---------- ------------------ ---------------------------------------------------------------------------------------------------- ----------------- ---------------- ------------------------------------------------------------
DB                         MON_TE                      1 NO     MON_TE_202410                                  0 TO_DATE(' 2024-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')                                 83 DISABLED
DB                         MON_TE                      2 NO     SYS_P5846                                      0 TO_DATE(' 2024-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')                                 83 DISABLED

发现除了提示备份错误的10月分区之外只有一个命名为SYS开头的分区。看到SYS开头想到这张表可能是系统自动分区，而exp又不支持备份自动分区的表。从DBA_PART_TABLES视图查看具体情况，着重观察INTERVAL字段是否有内容

 select OWNER,TABLE_NAME,PARTITIONING_TYPE,INTERVAL from dba_part_tables where table_name='MON_TE' and OWNER='DB';

OWNER                          TABLE_NAME                     PARTITIONING_TYPE     INTERVAL
------------------------------ ------------------------------ ------------------ --------------------------------
DB                              MON_TE                         RANGE              NUMTOYMINTERVAL(1,'MONTH')

果然这是一张自动分区的表，按照一月一分区自动创建，这就解释为什么Exp备份日志提示备份这张表错误。