Export an empty table at oracle11g and at oracle11g
Deferred_segment_creation Parameter
This parameter indicates whether to create a segment immediately when an object (such as a table) is created without data at the beginning. The default value is true. This will cause objects without segment not to be exported during user-based export.
Solution
First, execute the following statement:
Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;
After the execution, copy the queried SQL data.
Then execute:
Alter system set deferred_segment_creation = false;
Finally, execute the copied SQL data.
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.