11 GB Oracle export tables do not export empty tables by default. 11 goracle

11 GB Oracle export tables do not export empty tables by default. 11 goracle

When exporting a table in oracle for 11 GB, no data is exported by default.

1. By default, no segment is assigned to the empty table at Oracle11g. Therefore, when you use exp to export the Oracle11g database, the empty table is not exported.
2. After the deferred_segment_creation parameter is set to FALSE, segment is assigned to both empty and non-empty tables.
In sqlplus, run the following command:
SQL> alter system set deferred_segment_creation = false; view:
SQL> show parameter deferred_segment_creation;
After this value is set, it only applies to the newly added tables and does not apply to the empty tables created previously.

Solution:

1. Use the following statement to search for an empty table and generate an execution command.
Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;

2. Export the query result and execute the Export Statement.

3. Then use exp to export the database, and you can completely export the database including empty tables.

How can I export an empty table when exporting a database at oracle11g?

1. Export the database TEST completely, and the username system Password manager is exported to D: \ daochu. dmp.
Exp system/manager @ TEST file = d: \ daochu. dmp full = y
2. Export the tables of system users and sys users in the database
Exp system/manager @ TEST file = d: \ daochu. dmp owner = (system, sys)
 
How can I export an empty table when exporting a database at oracle11g?

Take a look at this document.