ORACLE11G reasons for using EXP to export table incomplete problems and solutions ____oracle

Reason: There is a feature in oracle11g that if a table has never been used, the database system does not assign segments to the table, and only saves its structure in the data dictionary. This way, a table that has never been used will not be exported using the EXP command.

Solution:

The first: Each table is added false data, and then exported;

Second: Execute ALTER system set DEFERRED_SEGMENT_CREATION=FALSE command. Note that after this command is executed, the newly created table will not work, so rebuild the original table. We can use Pl/sql Developer this tool to rebuild. Right-click the table you want to rebuild, and then select Edit from the menu that pops up. Select the "Recreate table" option on the pop-up page, and then click the Apply button, and note:

I was reminded that this would delete all the data from this table (this doesn't matter), triggers, or foreign key references. So be careful to use it carefully.

The third: You think, there should be other ways, anyway let the system to the table allocation segment on the line.