• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

import oracle dump


I have a oracle dump file from oracle 11 g database (xyz.dump). Please let me know how to import  that into my oracle 11g db..

I am little unsure how to proceed

thanks bunch
  • 2
2 Solutions
slightwv (䄆 Netminder) Commented:
There are to many questions to really answer here.

I suggest the online docs:
There are two imports depending on how the export was created.  imp or the new datapump impdp.

There are numerous parameters that you may or may not need.  You may or may not need to precreate tablespaces/users/etc...

It all depends on how the export was created and what you need from it.

Everything is covered in the utilities guide:
luser9999Author Commented:
impdp command works for me.....

luser9999Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now