Import Oracle .dmp file using SQL Developer

Question

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.

are · Accepted Answer · 2015-11-11 23:29:50Z

12

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

DataPump expdp util and you need import it by using impdp util
the file can be exported by exp util and you can import it by imp util
how to use this DataPump utils via SQL Developer UI see here

answered Nov 11, 2015 at 23:29

are

2,6153 gold badges24 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sarath · Accepted Answer · 2019-10-15 09:05:28Z

0

Simple and easy step

Set Oracle Home Path in env.property

ORACLE_HOME = Path

imp 'sys/admin AS SYSDBA' file=C:\Oracle_DB_Dump.dmp full=Y

answered Oct 15, 2019 at 9:05

sarath

90313 silver badges20 bronze badges

Collectives™ on Stack Overflow

Import Oracle .dmp file using SQL Developer

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related