Environmental Science:Centos7.4 oracle18.104.22.168 (building RAC cluster)
Problem Description:When using exp command to export, some tables prompt “exp-00003: storage definition of segment (0,0) not found” warning.
Cause of the problem:This problem is caused by the exported data table is empty. Oracle 11gr2 does not allocate segments to save space when there is no data in the table, so empty tables cannot be exported when exporting with export.
1. Use the following statement to find the empty table, export the query result, modify the segment value forcibly, and then export to export the empty table.
Note: the statements may not find all the tables (some may be missing). If there is any missing, you can execute the following alert statement according to the export log.
2. Insert a record into the corresponding empty table and delete it (or roll back). This produces segments. When exporting, empty tables can be exported.
3. Set deferred_ segment_ The creation parameter. The default value of this parameter is true. When it is changed to false, segment is assigned to both empty and non empty tables.
Note: after the value is set, it will not affect the previously imported empty tables, but can not be exported. It can only affect the newly added tables. If you need to export the previous empty table, you can only use the first two methods.