How to import dmp files in navicat

1. Installation method:

1. First download Navicat Premium and Oracle Database

Oracle Database official website download address: https://www. oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Note: Both file1 and file2 of Oracle Database must be downloaded.

2. Then unzip the two files and put them into a folder. Here is my placement location. I put the components folder of file2 into the database folder of file1.

#3. Finally, click the setup.exe program in file1 to install.

Related recommendations: "Navicat for mysql graphic tutorial"

4. To use navicat to connect to the Oracle database, you need to download two files. Official website address: https://www.oracle.com/technetwork/topics/winx64soft-089540.html.

5. These two locations can be placed at will, in navicat "Tools"--"Options"--"Others"--"OCI".

Put oci.dll in the instantclient-basic-windows.x64-11.2.0.4.0 folder downloaded in 4 into OCI library.

Put sqlplus.exe in the instantclient-sqlplus-windows.x64-11.2.0.4.0 folder downloaded in 4 into SQL*Plus.

The connection will be successful after that. (Under normal circumstances, if it is not normal, I encounter a situation: everything downloaded (all things related to Navicat and Oracle) must be the same, that is, everything that is 64-bit (32-bit) must be 64-bit (32-bit). ).)

2. Import Data Pump (.dmp)

1. Create a directory and place the .dmp file in the directory.

2. Click "Data Pump"--""Data Pump Import" above (there may be a "SYSDBA role required" prompt here, operation: When connecting, click Advanced Just select the SYSDBA role. If that doesn't work, try this: This is to log in to Oracle using the command window (enter sqlplus /as sysdba). After the connection is successful, execute grant sysdba to user name;)

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