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

import oracle dump

Hi,

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
0
luser9999
Asked:
luser9999
  • 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:
http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/toc.htm
0
 
luser9999Author Commented:
impdp command works for me.....


thanks
0
 
luser9999Author Commented:
thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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