ORACLE import and export operations

1. Import command:

Imp userId/psw @ orcl full = y file = D: \ data \ xxx. dmp ignore = y

2. Export commands

Exp userId/psw @ orcl file = d: \ dkj \ test. dmp tables = (wf_test)
Exp userId/psw @ orcl buffer = 50000000 file = D: \ data \ xxx. dmp owner = userId

 

 

1. After installing ORACLE 11g, run the following command in sqlplus:
SQL> alter system set deferred_segment_creation = false;

Both empty and non-empty tables can be imported and exported.

 

2. in oracle 11g, "PASSWORD_LIFE_TIME = 180" is set in the default profile by default. As a result, the password of the oracle user must be changed within 180 days, otherwise, the connection will fail when you start the database.

Change the default 180 days to "unlimited". log on to sqlplus:
SQL> alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;

After modification, the database does not need to be restarted and takes effect immediately.

 

Please note !!!

1. By default, no segment is assigned to the empty table at Oracle11g. Therefore, when you use exp to export the Oracle11g database, the empty table is not exported.

2. After the deferred_segment_creation parameter is set to FALSE, segment is assigned to both empty and non-empty tables.
In sqlplus, run the following command:
SQL> alter system set deferred_segment_creation = false;
View:
SQL> show parameter deferred_segment_creation;

After this value is set, it only applies to the newly added tables and does not apply to the empty tables created previously.

After installing oracle 11g, you must promptly follow the above steps to set

If the table with zero rows of records is not displayed during import and export using our current database, the above settings are not performed.