Oracle 11G Note: A workaround for an empty table cannot be exported

Recently in Oracle 11G. An issue was found when importing data exports: Oracle does not export empty tables with no data. The data found that this is the case only in Oracle 11g, the process is as follows:

• Sqlcommand:alter system set Deferred_segment_creation=false;

This means that it is forbidden to postpone the creation of a segment of a table, that is, when the table is created, regardless of whether there is data. This parameter is modified to be useless for tables created before that point in time. So you still have to allocate space for the previous table.

• Sql:select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0 or num_rows is null

  The above-spelled SQL can be bulk-generated to modify a table with empty allocation space. Perform the following for the results of the query. The Export command for exp or EXPDP is now available.

Oracle 11G Note: A workaround for an empty table cannot be exported