Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to solve the problem that oracle11g empty tables can not be exported by exp". In daily operation, I believe many people have doubts about how to solve the problem that oracle11g empty tables can not be exported by exp. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for everyone to answer "how to solve the problem that oracle11g empty tables can not be exported by exp". Next, please follow the editor to study!

SQL > show parameter deferred_segment_creation

NAME TYPE VALUE

Deferred_segment_creation boolean TRUE

Database parameter deferred_segment_creation=true, which will prevent dmp backup from exporting empty table structure

SQL > alter system set deferred_segment_creation=false

This method is only valid for later tables, and the previous table still has no space allocated.

1. First query all the empty tables under the current user, and give priority to using segment_created = 'NO'

Select * from user_tables where segment_created = 'NO'

-- select table_name from user_tables where NUM_ROWS=0

2. Batch generate modification statements

Select 'alter table' | | table_name | | 'allocate extent;' from user_tables where segment_created =' NO'

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

3. Execute the modification statement

Alter table table name allocate extent

At this point, the study on "how to solve the problem that oracle11g empty tables cannot be exported by exp" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.