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

A new feature in ORACLE 11G is that when the table has no data, segment is not allocated to save space.

Alter system set deferred_segment_creation=false

The default value of this parameter is TRUE, and when changed to FALSE, segment is assigned to both empty and non-empty tables.

It should be noted that this value has no effect on the previously imported empty tables and still cannot be exported, but can only have an effect on the newly added tables.

Query empty tables that have been previously created

Select 'alter table' | | table_name | | 'allocate extent;' from user_tables where num_rows=0

Export the query results and execute the exported statement

'ALTER TABLE' | | TABLE_NAME | | 'ALLOCATE EXTENT;''

If there are few tables, you can insert a row in the empty table and then delete it, so that the database table will be assigned segment.

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.