Oracle11g exp export problem: some tables cannot be exported, oracle11gexp

Oracle11g exp export problem: some tables cannot be exported, oracle11gexp

An issue found during command exp export from oracle is that some tables cannot be completely exported. After checking, it is found that any blank table cannot be exported.

In the following table, it is found that segment_created cannot be exported for NO. After query, extract the statement and execute it.

Select 'alter table' | table_name | 'allocate extent ;'
From user_tables where segment_created = 'no ';

Alter table allocate extent;

Note: One feature in 11g is the deferred_segment_creation parameter. The default value is true, indicating that the segment creation is delayed. When a new table is created and the table has no data

The table does not allocate extent. Therefore, the table does not occupy data space, and no segment is allocated. As a result, exp cannot be exported. Therefore, based on the above method, query the user_tables table. If segment_created is NO, NO segment is allocated to the table, and execute the query.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.