Shulou(Shulou.com)06/01 Report--

Today, I am migrating the database from 11.2.0.1 to 11.2.0.4. I used exp to export all the objects under a user. When I did imp import, I found that the tables were much less. After reading the log, I found that some empty tables were not exported. After looking it up on the Internet, it is found that it is a new feature in 11G. When the table has no data, segment is not allocated to save space. Tables without Segment are not exported when using the exp command.

Article on the solution:

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

Finally, we adopted the third:

Concatenate a sentence with SQL: select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0

:

Alter table BUSEXTINFO allocate extent

Alter table BUSCHECKINFO allocate extent

Alter table HOMEMEMBER allocate extent

Alter table BUSASSEMBLYINFO allocate extent

Alter table BUSASSEMBLYHISTORY allocate extent

Alter table ASGNEMPDUTYPLUS allocate extent

Alter table JX_MAINTAINPEOPLELD allocate extent

Alter table MCBUSOILSTANDARDGS allocate extent

Alter table MCBUSOILSTDDETAILDGS allocate extent

Alter table FDISARRSEQUENCETIMELD allocate extent

Alter table FDISARRSEQUENCETMPLD allocate extent

.

Finally, execute these statements once and OK!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.