An export error (EXP-00003) for a table in the dump export database in Oracle failed to find the storage definition for segment (0,0)

The following issues occurred when using the Oracle database for the first two days, using the DBA user to export table structures in the tool in PL/SQL, when exporting tables:

A lot of table "error (EXP-00003) did not find the segment (0,0) storage Definition", the results, after finding relevant data, comparison table structure, and finally found that all reported this error table is empty table---the table has no data. Know this feature, by looking for data, eventually found that the problem is "ORACLE11GR2 has a new feature, when the table has no data, do not allocate segment, to save space without any records, no allocation segment caused by, in the end, the reason for delay partitioning." Why this problem, understand, then is to solve.

My solution is as follows:

By select ' ALTER TABLE ' | | table_name| | ' allocate extent; ' from User_tables where num_rows=0; The resulting SQL results in an ALTER statement for each table, which is then exported using PL/SQL's export CSV file, and then the CSV file is opened, and all the alter SQL statements are copied to the live window of PL/Windows.

After the execution of the export, problem resolution.

An export error (EXP-00003) for a table in the dump export database in Oracle failed to find the storage definition for segment (0,0)