Import and export of Oracle11g

 

When oracle 11g exports a database using exp, empty tables cannot be exported. Therefore, you must use a Data Pump to import and export the oracle database.

 

1. expdp

 

SQL> create directory name (for example, dmpbx) as storage address (for example, '/root/usr /...... ');

 

The directory has been created.

 

SQL> grant read, write on directory name to public;

 

Authorization successful.

 

SQL> exit

 

Expdp username 1/password @ instance dumpfile = backup file name (ecology. dmp) directory = directory name (dmpbx)

 

2. impdp

 

SQL> create directory name (for example, dmpbx) as storage address (for example, '/root/usr /...... ');

 

The directory has been created.

 

SQL> grant read, write on directory name to public;

 

Authorization successful.

 

SQL> exit

 

Impdp username 2/password @ instance directory = directory name dumpfile = backup file name. dmp logfile = log name. log REMAP_SCHEMA = username 1: username 2

 

If impdp is operated on the same machine, the steps for creating directories and granting permissions before impdp can be omitted.

 

From andy's column