Oracle Database Export and Import

Oracle Database Export and Import

You need to export data from Oracle Database A as A *. dmp file, and then import the *. dmp file to database B.

1. Export Database

Enter the following command in the cmd window:

Export all databases

Exp username/password @ database name file = d: \ *. dmp full = y

Export the database of the current user

Exp username/password @ database name owner = (username) file = d: \ *. dmp

2. Connect to database B

Run the following command under SQL plus:

Conn sys/sys as sysdba;

3. Create a user

Create user Username identified by password;

4. Grant dba permissions to users

Grant connect, resource, dba to user name;

5. Import database

Run the following command in cmd:

Import the entire database to a user

Imp username/password @ database name full = y file = d: \ *. dmp ignore = y

Import a table to the user

Imp username/password @ database name file = d: \ *. dmp tables = (table name)

At this point, the Oracle database has been exported and imported, and the deployment is expected to be completed normally tomorrow.