(学) Oracle11G exp时可以导出空表

1、

ALTER SYSTEM SET deferred_segment_creation=FALSE SCOPE=MEMORY;
ALTER SYSTEM SET deferred_segment_creation=FALSE SCOPE=SPFILE;
alter system set processes=400 scope=spfile;

2、

Select 'alter table '||table_name||' allocate extent;' from user_tables where num_rows=0