ORACLE11GR2 use exp to export command times EXP-00011 Error resolution _oracle

In the process of training customers, it is found that there is a strange phenomenon in the client database server. The client Database server environment is AIX6+ORACLE11GR2, as follows:

When performing EXP export, some table hints EXP-00011: The table does not have an error, but querying the User_all_tables view, the table does exist, and executing the SELECT statement succeeds, although the table is empty, and viewing permissions is no problem. Later, by querying the data, it was found that the problem was caused by deferred Segment creation parameters.

Deferred Segment creation, delay segment creation, ORACLE11GR2 new parameters, specifically when you create a new object that might have Segment, if there is no record in this object that consumes a extent, This will not automatically create the segment when the object is created, and the benefit is that it greatly increases the speed when the object is created. However, because the object is not segment, the EXP-00011 error is reported when the EXP export is performed.

Take the error table Cf_template for example, and execute the following query:

Copy Code code as follows:

Sql> Show Parameter Deferred_segment_creation

NAME TYPE VALUE

------------------------------------ -------------------- --------------------

Deferred_segment_creation Boolean TRUE

Found deferred Segment creation has been opened and then executed:

Copy Code code as follows:

Sql> Select Segment_name from user_segments where segment_name= ' cf_template ';

No rows selected

There is no return value, the database does not create segment for the Cf_template table, which verifies why the error is empty.

The workaround is as follows:

1. Set the value of Deferred_segment_creation to False

This method is only valid for future tables, and the previous table is not segment or not.

2. Declare create segment immediately when creating a table

CREATE table xxx (xxx xxx) SEGMENT creation IMMEDIATE;

3. For tables that have been created but not yet Segment, you can execute ALTER TABLE XXX allocate extent to create Segment, or you can insert a piece of data to create Segment