Oracle 11G 出现EXP-00003: 未找到段 (0,0) 的存储定义



EXP-00003:no storage definition found for segment(number, number)

Cause: Export could not find the storage definitions for a cluster, index, or table.

Action: Record the accompanying messages and report this as an Export internal error to customer support.

 

Oracle 11G使用exp无法导出空表的定义。

 

解决方法:将空表分配段来满足导出条件。

 

1、查找空的对象有哪些：

   select table_name from user_tables where num_rows=0;

    

2、拼出给空表分配段空间语句：

   set pagesize 200

     select ‘alter table ‘||table_name||’ allocate extent;’ from user_tables where num_rows=0; 

    执行拼出的语句即可。

 

之后，调整，使得之后新建的空表可以被导出。

alter system set DEFERRED_SEGMENT_CREATION=FALSE;

DEFERRED_SEGMENT_CREATION specifies the semantics of deferred segment creation. If set to true,then segments for tables and their dependent objects (LOBs, indexes) will notbe created until the first row is inserted into the table.

Before creating a set of tables, if it is known that asignificant number of them will not be populated, then consider setting thisparameter totrue. This saves disk space and minimizes install time.

该bug在11.2.0.4已修补