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

ORACLE 11G is being used recently. A problem was found when exporting and importing data: oracle does not export empty tables with no data. Checking the data, it is found that this situation only occurs in Oracle 11g, and the treatment methods are as follows:

Sqlcommand: alter system set deferred_segment_creation=false

It means that deferring the creation of table segments is prohibited, that is, space is allocated with or without data after the table is created. This parameter is modified to have no use for tables created previously at that point in time. So you still have to allocate space to the previous table.

Sql: Select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0 or num_rows is null

The SQL spelled out above can be used to generate tables with empty allocation space in batch. Execute the results of the query as follows. Now you can do the export command of EXP or EXPDP.

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.