How to Import a DMP file into Oracle
Step By Step
Step 1: Open a Command Prompt or Terminal
On Windows, open the Command Prompt.
On Linux/Unix, open a terminal.
Step 2: Run the impdp Command
Use the following syntax to run the impdp command:
impdp username/password DUMPFILE=dumpfile_name.dmp DIRECTORY=directory_object
Replace username with the username of a user with sufficient privileges to perform the import.
Replace password with the password for the specified username.]
Replace dumpfile_name.dmp with the name of the DMP file you want to import.
Replace directory_object with the logical directory object that points to the physical directory where the DMP file is located.(Most Important aspect)
Step 3: Execute the Command
Execute the impdp command you constructed in the previous step.
Example :- impdp system/system dumpfile=MY_DMP_FILE.DMP directory=MYDIR
20 авг 2023
