Oracle EXP-00011 export data space time table error Solution

This problem occurs when Oracle exp exports tables and data (when the 10g client is used to export 11g tables and data everywhere );

The solution is as follows:

1. Set the value of deferred_segment_creation to false.

This method is only valid for later tables. The previous tables do not have Segment or are not.

2. Declare to create a Segment immediately when creating a table

Create table XXX (XXX) segment creation immediate;

3. For a table that has been created but does not have a Segment, You can execute alter table XXX allocate extent to create a Segment. Of course, you can also insert a piece of data to create a Segment.

The final solution:

First, query which tables are empty:

Select table_name from user_tables where NUM_ROWS = 0;

The following statement is generated using select:

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

Then copy and execute the generated modification statement to solve the problem.