Shulou(Shulou.com)06/01 Report--

This article mainly introduces the method of importing navicat into dmp, which is very detailed and has certain reference value. Friends who are interested must finish reading it!

1. Installation method:

1. Download Navicat Premium and Oracle Database first

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

Note: both file1 and file2 of Oracle Database should be downloaded.

two。 Then unzip the two files and put them in a folder. This is where I put them. I put the components folder of file2 into the database folder of file1.

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

4. Two more files need to be downloaded to connect to the Oracle database using navicat. 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"-"other"-"OCI".

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

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

After that, you can connect successfully. (normally, if it's not normal, I come across a situation where everything you download (everything about Navicat and Oracle) has to be the same, that is, 64-bit (32-bit). )

Import data pump (.dmp)

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

two。 Click "data pump" above-"data pump Import" (there may be a "need SYSDBA role" prompt, operation: select the SYSDBA role in the advanced when connecting. If it doesn't work, try this: log in to Oracle from the command window (type sqlplus / as sysdba), and execute the grant sysdba to user name after the connection is successful.

The above is all the contents of this article "the method of importing navicat into dmp". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.