Importing a table in oracle says that the table does not exist, Oracle 11g plsql cannot export an empty table, exp EXP-00011: The table does not exist

Oracle 11g plsql cannot export empty tables, exp EXP-00011: The table does not exist

oracle11g has a new feature, adding a new feature “deferred_segment_creation” meaning segment delay creation, the default is true, if this parameter is set to true, you create a new Table, and do not insert data into it, then this The table does not allocate extend immediately, that is, it does not occupy data space, that is, the table does not allocate segments to save space, so these tables cannot be exported. If the segment_treated field in the table is “NO” or “YES”, it indicates whether a table is allocated a segment.

Check whether the table is assigned a segment

SELECT TABLE_NAME,SEGMENT_CREATED FROM USER_TABLES

See deferred_segment_creation

show parameter deferred_segment_creation;

Modify deferred_segment_creation

alter system set deferred_segment_creation=false;

Note: After modifying to false, the created table will allocate space immediately, but the table before adjustment will not change, you need to manually modify the allocated space

1.SELECT ‘ANALYZE TABLE ‘ || TABLE_NAME || ‘ COMPUTE STATISTICS;’ from USER_TABLES where NUM_ROWS=0;

2. Execute query results

3. SELECT ‘alter table ‘||TABLE_NAME||’ allocate extent;’ from USER_TABLES where NUM_ROWS=0;

4. Execute query results

or

1.SELECT ‘ANALYZE TABLE ‘ || TABLE_NAME || ‘ COMPUTE STATISTICS;’ from USER_TABLES where NUM_ROWS=0 OR NUM=ROWS IS NULL;

2. Execute query results

After completion, you can use exp to export the empty table normally