0

I'm trying to import a dmp file in my database, so far this is the steps I've followed in a guide about how to import a dmp file in SQLDeveloper:

Open SQL Developer and connect to your database. Go to View > DBA to open the DBA panel. If no connection exists, click the "+" icon, choose your database connection, and click OK. Expand the connection node in the DBA panel. Locate Data Pump under the connection.

But I cannot fulfill the 5th step, the options that appear are the following:

Available options

I'm traslanting first and fourth option just in case it's needed, that means Basic and Advanced.

I've already checked those options and none of them seem to allow the import of a dmp file.

Is there any way to make the mentioned option in the guide to appear or to do the import of the dmp file via those options?

Maybe the problem lies on the version of SQLDeveloper I'm using, the version is 4.0.2.15 Internal version 15.21.

1
  • That is an old version, but Data Pump was in the DBA panel from version 3.x - could it be a permissions issue? Does your user have the datapump roles? I'm running SQL Developer Version 22.2.0.173 and can see the Data Pump under the DBA panel, but I am connected as SYSDBA Commented Nov 25 at 0:56

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.