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

Two days ago, when using the oracle database and using dba to export the table structure using export table in tool in PL/SQL, the following problems occurred:

Many tables "EXP-00003 did not find the storage definition of the segment (0P0)". After looking up the relevant information and comparing the table structure, we finally found that all the tables that reported this error were empty-that is, there was no data in the table. After knowing this feature, by looking up the data, we finally found that "there is a new feature in oracle11GR2, when the table has no data, it does not allocate segment, so as to save space. There is no record, and it is caused by no allocation segment. In the final analysis, it is the cause of delayed partitioning." Why this problem arises, it is figured out, and then it will be solved.

My solution is as follows:

The result found by the sql generated by select 'alter table' | | table_name | 'allocate extent;' from user_tables where num_rows=0; is the alter statement of each table, then export all the generated sql in the form of PL/sql export csv file, then open the csv file, and copy all alter sql statements to the life window of PL/SQL for execution.

Export after execution, and the problem is solved.

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.