ORACLE Import and export operations

1. Import command:

Imp Userid/[email protected] full=y file=d:\data\xxx.dmp ignore=y

2. Export command

Exp Userid/[email protected] file=d:\dkj\test.dmp tables= (wf_test)
Exp Userid/[email protected] buffer=50000000 file=d:\data\xxx.dmp Owner=userid

1. After installing Oracle 11g, in Sqlplus, execute the following command:
Sql>alter system set Deferred_segment_creation=false;

Import and export Whether it is a blank table or a non-empty table

2. In Oracle 11g, the default profile is set to "password_life_time=180", causing the Oracle user's password to be changed within 180 days, or the connection failure will be prompted when the database is started.

Change the default 180 days to "unlimited" and log in to Sqlplus:
Sql>alter profile default limit password_life_time UNLIMITED;

You do not need to restart the database after you modify it, it takes effect immediately.

PLEASE NOTE!!!

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.

Set up your Oracle 11g in a timely manner as described above

Use our current library when doing import and export if you do not see 0 rows of recorded tables, indicating that the above settings are not done