Oracle 11g empty table export Method

1. Open pl_ SQL and log on to the user who needs to export the database

Ii. Create an SQL copy

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

The query result is as follows:

3. Create an SQL window and paste all the information copied and queried in the blank space.

For example:

4. After the execution is successful, start-run on the Oracle 11g server and enter the Database Export Statement (for example, exp shemis3/oracle9i @ emis file = 'e: \ shemis20121211.dmp ') to export all the tables in the database.