Oracle 11g export database does not export empty tables, oracle11g

Oracle 11g export database does not export empty tables, oracle11g

Oracle11g may encounter such a problem. When using exp to export the entire database, this problem occurs, and empty tables in the database cannot be exported.

Select * from all_all_tables aa where aa. owner = 'user name write' --- view all tables under the User

Select * from all_tables t where t. owner = 'user name write' and t. num_rows = 0; -- view all empty tables under the User

Okay, the following is the processing method script:

Run the following command in the Command window:

Set heading off;
Set echo off;
Set feedback off;
Set termout on;
SpoolD: \ allocate. SQL;
Select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;
Spool off;

 

After runningAllocate. SQLRun it again in the Command window, and then use the exp statement, so that the empty table can be exported.