The Oracle 11g empty table cannot be exported.

The Oracle 11g empty table cannot be exported.

The deferred_segment_creation parameter is added to the Oracle 11g. The default value is true when the database is created. This parameter means delayed loading. When no data exists in the table, no space is created for the table, when you export data, you will find that many tables do not exist.

Run the show parameter deferred deferred_segment_creation command to view the value of deferred_segment_creation.

Method 1: insert values in the image library table

Method 2: 1. Run the SQL statement to modify the value of deferred_segment_creation: alter system set deferred_segment_creation = false;

2. Run the SQL statement: select 'alter table' | table_name | 'allocate extent; 'from user_tables where num_rows = 0;

Use pl/SQL to right-click the result and copy it to Excel... copy the result to the SQL window and run it. Then you can export the result.

Oracle 11g tablespace dbf File migration

Solutions for moving Oracle tablespace data files

Deleting temporary tablespace ORA-25152 Error

Oracle tablespace growth exception solution: Another example

Three parameters of Oracle tablespace Offline

Use of encrypted tablespace under Oracle 11 GB