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

After oracle11g is established, execute the following statement to prevent the problem that empty tables cannot be backed up (previously established tables need to be dealt with in the following way)

Alter system set deferred_segment_creation=false

Execute the following sql to execute the result, which is ready for backup.

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

If an imp-00017 ora-06550 error occurs during imp, the solution is:

Is to add a parameter to exp or imp to disable the export / import of statistics: statistics=none

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.