Skip to Main Content
  • Questions

  • What is the directory in an impdp operation

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, ahmed.

Asked: August 09, 2017 - 12:53 pm UTC

Last updated: August 10, 2017 - 8:37 am UTC

Version: oracle 10g

Viewed 1000+ times

You Asked



I have new server and i installed oracle 10g same like production. and i Have databump full backup using sys user, i need to restore on the new server.

I used the following command while database is not mounted but asks for directory parameter

impdp full=y direcotry=/home/oracle/rmanscripts/dumbbackup dumpfile=sysfull.dmp logfile=full_db.log

please share me the steps to restore the database to a new server!

and Connor said...

A directory is a database object not a physical reference. So you would do this in your *target* database:

connect system/password
create directory IMP_LOCATION as '/home/oracle/rmanscripts/dumbbackup';
grant read, write on directory IMP_LOCATION to ... -- if needed

impdp full=y direcotry=IMP_LOCATION dumpfile=sysfull.dmp logfile=full_db.log

Rating

  (5 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

ahmed elsafi, August 10, 2017 - 5:31 am UTC

hi Connor, thanks for you response
but my target database is not open.
i installed oracle software only and no database running.
Connor McDonald
August 10, 2017 - 8:37 am UTC

To do the restore you:

a) create a target database
b) import the dumpfile

ahmed elsafi, August 10, 2017 - 6:14 am UTC

hi Connor, thanks for you response
but my target database is not open.
i installed oracle software only and no database running.

ahmed elsafi, August 10, 2017 - 6:18 am UTC

hi connor, thanks for your response.
but my database in open.
i install oracle software only.
so i cannot create directory in idle instance

ahmed elsafi, August 10, 2017 - 6:20 am UTC

hi connor, thanks for your response.
but my database in open.
i install oracle software only.
so i cannot create directory in idle instance

ahmed, August 10, 2017 - 6:53 am UTC

hi connor, thanks
but my database is not open since i install oracle software only, so the database instance is idle and i can create directory us sqlplus
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.