Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Import Oracle .dmp file using SQL Developer

I want to import a .dmp file exported from another database, and I was wondering if anyone have experience on using GUI import option for .dmp file from SQL Developer? I have searched a lot of documents, but I couldn't find any detail. I can use SYS or SYSTEM user to import.

like image 576
Lin Ma Avatar asked Nov 11 '15 22:11

Lin Ma


People also ask

How do I import a .dmp file into Oracle SQL Developer?

Right-click on either the "Data Pump" or "Import Jobs" tree node and select the "Data Pump Import Wizard..." menu option. Enter the type of import you want to do and the name of the dump file that is the source of the data, then click the "Next" button.

How do you take a DB dump in SQL Developer?

Using the main menu, select Tools->Database Export. An Export wizard will open. At the top of the screen, enter a directory and file name.


1 Answers

what was this another database? was it oracle database? if yes the dmp file can be file exported by

  1. DataPump expdp util and you need import it by using impdp util
  2. the file can be exported by exp util and you can import it by imp util
  3. how to use this DataPump utils via SQL Developer UI see here
like image 185
are Avatar answered Oct 04 '22 03:10

are