In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.