1, oracle11g default to Empty table is not assigned segment, so use EXP export oracle11g database, empty table is not exported.
2. After setting the Deferred_segment_creation parameter to False, both the empty table and the non-empty table are assigned segment.
In Sqlplus, execute the following command:
Sql>alter system set Deferred_segment_creation=false;
View:
Sql>show parameter deferred_segment_creation;
This value is set only after the newly added table, which has no effect on the previously established empty table.
To manipulate a command procedure:
Microsoft Windows [version 6.1.7600] Copyright (c) Microsoft Corporation. All rights reserved.
C:\users\administrator>show parameter deferred_segment_creation; ' Show ' is not an internal or external command, or a program or batch file that can be run.
C:\users\administrator> Conn system/as SYSDBA ' Conn ' is not an internal or external command, nor is it a program or batch file that can be run.
C:\users\administrator>sqlplus
Sql*plus:release 11.2.0.1.0 Production on Saturday November 22 15:21:02 2014
Copyright (c) 1982, Oracle. All rights reserved.
Please enter user name: System input Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing Options
Sql> Show parameter deferred_segment_creation;
NAME TYPE VALUE----------------------------------------------------------------- ------------Deferred_segment_creation boolean TRUE sql> alter system set Deferred_segment_creation=fals E
The system has changed.
Sql> con infomgr/1q2w3e123 sp2-0734: Unknown command at the beginning of "Con infomg ..."-ignores the remaining rows. sql> con infomgr/[email protected] sp2-0734: Unknown command at the beginning "Con infomg ..."-ignores the remaining rows. Sql> quit from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mi Ning and Real application testing options Disconnect
C:\users\administrator>sqlplus
Sql*plus:release 11.2.0.1.0 Production on Saturday November 22 15:22:57 2014
Copyright (c) 1982, Oracle. All rights reserved.
Please enter username: infomgr Enter password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing Options
Sql> Show Parameter Deferred_segment_creation
NAME TYPE VALUE----------------------------------------------------------------- ------------Deferred_segment_creation boolean FALSE sql> from Oracle Database 11g Enterprise Edition Relea Se 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and Real application testing options Disconnect
C:\users\administrator>sqlplus
Sql*plus:release 11.2.0.1.0 Production on Saturday November 22 15:23:54 2014
Copyright (c) 1982, Oracle. All rights reserved.
Please enter user name: System input Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing Options
sql> Shutdow Immediate; ORA-01031: Insufficient permissions sql> Sys/as DBA sp2-0734: Unknown command begins with "Sys/as db ..."-ignores the remaining rows. Sql> quit from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mi Ning and Real application testing options Disconnect
C:\users\administrator>sqlplus
Sql*plus:release 11.2.0.1.0 Production on Saturday November 22 15:25:15 2014
Copyright (c) 1982, Oracle. All rights reserved.
Please enter user name: System/as sysdba Enter Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production with the partitioning, OLAP, Data Mining and R EAL Application Testing Options
sql> Shutdow Immediate; The database is closed. The database has been uninstalled. The ORACLE routine has been closed. Sql> startup; The ORACLE routine has been started.
Total System Global area 1071333376 bytes Fixed size 1375792 bytes Variable Size 578814416 by TEs database buffers 486539264 bytes Redo buffers 4603904 bytes databases loaded. The database is already open. Sql>
Oracle 11g cannot export an empty table workaround