How to import dmp from oracle database

How to import DMP files of Oracle database: Get DMP files; use Oracle Data Pump import utility (impdp); connect to the target database; execute import commands, specify the DMP file path and target schema (optional); wait for the import to complete; verify the import results.

How to import DMP files from Oracle database

Step 1: Get the DMP file

First, you need to get the DMP file you want to import. This file contains backups of the database schema and data.

Step 2: Use Oracle Data Pump Import Utility

To import DMP files, you need to use the Oracle Data Pump Import Utility (impdp). It is a command line tool for importing data from external files into an Oracle database.

Step 3: Connect to the target database

Open a command prompt or terminal and connect to the target Oracle database using the following syntax:

 <code>impdp system/<password>@<database_name></database_name></password></code>

in:

• system is a username with sysdba permissions.
• is the user's password.
• is the name of the target database.

Step 4: Execute the import command

After connecting to the database, run the following command to import the DMP file:

 <code>impdp dumpfile=<dmp_file_path> remap_schema=<old_schema_name>:<new_schema_name></new_schema_name></old_schema_name></dmp_file_path></code>

in:

• is the path and file name of the DMP file.
• is the schema name (optional) of the data to be replaced.
• is the schema name (optional) of the newly imported data.

Step 5: Wait for the import to complete

The import process may take some time to complete, depending on the size of the DMP file and the performance of the database. You can use "ctrl c" to interrupt import.

Step 6: Verify the import

After the import is complete, you can run some queries to verify that the import is successful:

 <code>SELECT count(*) FROM <table_name>; SELECT * FROM <table_name> WHERE rownum </table_name></table_name></code>

The above is the detailed content of How to import dmp from oracle database. For more information, please follow other related articles on the PHP Chinese website!