Import/Export Database Schema

The following section shall discuss importing and exporting a database user schema in Oracle.

Exporting: The export process involves using a export tool from command line. Run the following command to generate a dump(*.dmp) file with all object definitions and data.

c:...\> exp username/password file=\path\db.dmp

To import the dump file into another database user, ececute the following command:

c:...\> imp username/password file=\path\db.dmp full=y