Oracle 11g export table reports EXP-00011: table does not exist

Oracle 11g, when backing up a database with the exp command, if the table does not have a datagram EXP-00011 error, the corresponding table does not exist. As a result, the corresponding empty table cannot be backed up.

Cause: by default, a segment is not allocated when a table is created at 11g, which is generated only when data is inserted (which can be forcibly allocated, of course) to save disk space.

Solution to an existing empty table:

It is to find a way to make the empty table have a segment. First, you can insert data (you can roll back the data if you do not want the data), and the segment will be allocated as long as there is an insert action;

Type 2: Forced allocation: alter table tablename allocate extent;

If the second method is used, you can use the following method:

1. Use the following statement to find an empty table: select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;

2. Export the query results and execute the Export Statement;

In order to directly allocate segment to the table created later:

Log on to the database with a system account and modify the deferred_segment_creation parameter (New in 11g ). This parameter indicates whether to delay segment creation. The default value is true. If you want to assign a segment when creating a table, set this parameter to false, that is, alter system set deferred_segment_creation = false. Then show parameter deferred deferred_segment_creation; as shown below:

Recommended reading:

How to install Oracle 11g on Linux

Detailed description of the installation process of Oracle 11g Database in Linux

How to install Oracle 11g R2 single-instance database on CentOS 5.6

To install Oracle Clusterware on an Oracle vmvm

Install Oracle 11 GB single-instance database on Linux under vmvm