Solution for using the exp command to export incomplete tables in Oracle11gR2

Some tables are lost when the full database is exported to the new database in the business database the day before yesterday. After reading the log, the analysis shows that some empty tables are not exported. Google knows that the new feature in 11g saves space by not allocating segment when the table has no data. When you use the exp command, tables without Segment will not be exported. Solution: wenku. baidu. comview

Some tables are lost when the full database is exported to the new database in the business database the day before yesterday. After reading the log, the analysis shows that some empty tables are not exported. Google knows that the new feature in 11g saves space by not allocating segment when the table has no data. When you use the exp command, tables without Segment will not be exported. Solution: http://wenku.baidu.com/view/

Some tables are lost when the full database is exported to the new database in the business database the day before yesterday.

After reading the log, the analysis shows that some empty tables are not exported. Google knows that the new feature in 11g saves space by not allocating segment when the table has no data. When you use the exp command, tables without Segment will not be exported.

Solution:

Http://wenku.baidu.com/view/7beb56f57c1cfad6195fa702.html

Adopt the third method:

Run the following statement to obtain the empty table:

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

Copy the execution result to another SQL window and execute similar statements:

ALTER TABLE COMJARREF ALLOCATE EXTENT;ALTER TABLE COMSTORE ALLOCATE EXTENT;ALTER TABLE DATASERVER ALLOCATE EXTENT;ALTER TABLE EIMP_COLUMNS ALLOCATE EXTENT;ALTER TABLE EIMP_TABLES ALLOCATE EXTENT;--...................................................................

And then export it. OK!

It is worth noting that, after the forced allocation, more than 200 empty tables are added, and the export file is changed from 10 MB to 102 MB, slightly increasing.

Helping others is the same as self-help! 3w@live.cn