Import data pump (.dmp)(Recommended tutorial: navicat tutorial)
Click [Others ]Create a [directory] and place the .dmp file in this directory.
Click [Data Pump] - [Data Pump Import] (There may be a "SYSDBA role required" prompt here, please operate : Just select the SYSDBA role in the advanced menu when connecting. 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 in navicat. For more information, please follow other related articles on the PHP Chinese website!