Oracle Database Export and Import Process

Oracle Database Export and Import process:
1. Export dmp files

Input: Run CMD? Exp(exp.exe under the binary directory of external oracle)

Username/password @ Database Name (for example, NCS_TEST/K @ GAICHU)

Export path (c: \ text. dmp)

A series of default carriage return

Exported

2. Import dmp files

Input: Run CMD? Imp( imp.exe under the binary directory of oracle)

Username/password @ Database Name (for example, NCS_TEST/K @ GAICHU)

Import path (c: \ text. dmp)

A series of default carriage return

Import completed

Note:

In case of an Oracle-12154 error, check whether the database name and password are correct.

The Oracle version on the client and server should be consistent.

As described above, you can easily Import and Export Oracle databases. The steps above also provide a clear explanation, hoping to help you.