[Go] easy to resolve oracle11g empty table cannot exp export issue

Transferred from: http://www.2cto.com/database/201109/105931.html

The new feature of oracle11g is that the number of data bars is 0 o'clock without assigning segment, so it cannot be exported.

Workaround:

1 Insert a piece of data (or delete it), wasting time, and sometimes hundreds of sheets will be exhausted.
2 before you create a database
Using code:

SQL code
alter system set DEFERRED_SEGMENT_CREATION=FALSE;

Adjust the re-build table
Neither of these sides is good.
Here's the ultimate approach:

First, check which tables are empty:

SQL code
Select table_name from user_tables where num_rows=0;


Below we will generate the modification statement by select:
SQL code
Select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0

The following items are then generated in the results window:

SQL code
ALTER TABLE e2user_state allocate extent;
ALTER TABLE Enterprise_e2user allocate extent;
ALTER TABLE Enterprise_info_type allocate extent;
ALTER TABLE Enterprise_mapmark allocate extent;
ALTER TABLE Enterprise_needtask allocate extent;
ALTER TABLE enterprise_picture allocate extent;
ALTER TABLE Enterprise_report allocate extent;
ALTER TABLE Enterprise_report_type allocate extent;
ALTER TABLE Enterprise_team allocate extent;
ALTER TABLE Fromuser_adjunct_target allocate extent;
ALTER TABLE Fromuser_offer allocate extent;
ALTER TABLE Needtask_type allocate extent;
ALTER TABLE Sys_privilege allocate extent;
ALTER TABLE Sys_relevance_resource allocate extent;
ALTER TABLE Sys_relevance_target allocate extent;
ALTER TABLE Sys_resource_type allocate extent;
ALTER TABLE Task_feedback allocate extent;
ALTER TABLE Task_mytasktype allocate extent;
ALTER TABLE touser_message allocate extent;
ALTER TABLE Aboutuser_point allocate extent;
ALTER TABLE Aboutuser_point_mark allocate extent;
ALTER TABLE Aboutuser_querykey allocate extent;
ALTER TABLE aboutuser_report_history allocate extent;
ALTER TABLE Dict_comment_type allocate extent;
ALTER TABLE Dict_industry_type allocate extent;
ALTER TABLE Dict_post allocate extent;
ALTER TABLE dict_region allocate extent;
ALTER TABLE enterprise_comment allocate extent;
ALTER TABLE Enterprise_comment_c allocate extent;
ALTER TABLE Enterprise_info allocate extent;
ALTER TABLE Enterprise_info_c allocate extent;
ALTER TABLE enterprise_info_state allocate extent;
ALTER TABLE Calendar_createtype allocate extent;
ALTER TABLE calendar_my allocate extent;
ALTER TABLE Calendar_type allocate extent;



OK execute those SQL above, then exp bar, that is witnessing the profound miracle.

The author was "Awake That night."

[Go] easy to resolve oracle11g empty table cannot exp export issue