oracle 11g 空表没法导出

oracle 11g 空表无法导出

?1、查看当前
show?parameter?DEFERRED_SEGMENT_CREATION;
1、设置参数值：
ALTER?SYSTEM?SET?deferred_segment_creation=FALSE?SCOPE=MEMORY;
ALTER?SYSTEM?SET?deferred_segment_creation=FALSE?SCOPE=SPFILE;
2、设置没有进行segment的表：
select?'alter?table?'||?a.table_name?||'?allocate?extent;'
??????????from?user_tables?a
?????????where?a.table_name?not?in
???????????????(select?segment_name
??????????????????from?user_segments
?????????????????where?segment_type?=?'TABLE');




将查询结果进行执行就可以了