Oracle cannot import the empty table solution. oracle Solution

Oracle cannot import the empty table solution. oracle Solution

Oracle cannot import empty tables

C: \ Users \ Administrator> sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Sunday August 17 19:24:29 2014

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

 

SQL> show parameter deferred_segment_creation

NAME TYPE VALUE
---------------------------------------------------------------------------
Deferred_segment_creation boolean TRUE
SQL>

 

SQL> alter system set deferred_segment_creation = false;

The system has been changed.

SQL>

 

 

Oracle exp cannot export empty tables. How can I export the structure of empty tables? How does imp import an empty table structure?

You can use the ROWS = N parameter during export and import.

What should I do if I want to export an empty table after exporting an ORACLE empty table and then creating a new table?

Alter system set deferred_segment_creation = false
This solution