oracle导出表数据不代表空间,expdp导出数据为什么也会报表空间不足的错误呢？...

expdp导出数据为什么也会报空间不足的错误呢？

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Aug 5 10:16:23 2011

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> select * from dba_directories where directory_name='DUMP_DIR';

OWNER                          DIRECTORY_NAME                 DIRECTORY_PATH

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS                            DUMP_DIR                       /ora_arch/backup/expdp

expdp sysdb/sysdb@sysdb EXCLUDE=table:\"IN \(\'SPECIALRATEMATRIX_0327\',\'TARIFFID_0327\',\'T_BME_SECURITYLOG\',\'SPECIALRATEM_TIME_0406\',\'SPECIALRATEM_TIME_0704\',\'TB_INTERACTLOG_4\',\'CBE_INTERMATRIXLST_0406\',\'CBE_INTERMATRIXLST_0704\',\'TB_SYNCCBPLOG\',\'TB_PRDSRVLOG_3\',\'T_BME_TASKRUNRESULT\',\'SPECIALRATEM_TIME_0327\',\'T_BME_RUNTIMELOG\',\'TB_PRDSRVLOG\',\'TB_INTERACTLOG\',\'OCS_MNP\',\'OCS_AIP_REQUEST\',\'OCS_RBT_MANAGELOG\',\'TB_MOBILENO_1\',\'TB_MOBILENO_3\',\'TB_MOBILENO_4\',\'TB_MOBILENO_6\',\'TB_MOBILENO_8\',\'TB_MOBILENO_2\',\'TB_MOBILENO_7\',\'TB_MOBILENO_0\',\'TB_MOBILENO_5\',\'TB_MOBILENO_9\'\)\" directory=dump_dir DUMPFILE=sysdb.dmp LOGFILE=sysdb.log

oracle@bmpdb1a:/ora_arch/backup/expdp> tail sysdb.log

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment SYSDB.SYS_LOB0000127644C00044$$ by 128 in tablespace CBS_DEFAULT_DAT

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment SYSDB.SYS_LOB0000127644C00044$$ by 128 in tablespace CBS_DEFAULT_DAT

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment SYSDB.SYS_LOB0000127644C00044$$ by 128 in tablespace CBS_DEFAULT_DAT

ORA-39171: Job is experiencing a resumable wait.

ORA-01691: unable to extend lob segment SYSDB.SYS_LOB0000127644C00044$$ by 128 in tablespace CBS_DEFAULT_DAT

官方解释：

Oracle Database Error ORA-01691

ORA-01691 unable to extend lob segment string.string by string in tablespace string

问题

Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.

解决

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

查表空间占用率，确实是tablespace CBS_DEFAULT_DAT上空间不足了

问题：

expdp导出数据为什么也会报空间不足的错误呢？

需要了解下expdp的工作机制

导入报空间问题是正常的，导出的时候也产生这类问题，能否解释下机制？