Solved

import oracle dump

Posted on 2011-09-21
3
488 Views
Last Modified: 2012-05-12
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
Comment
Question by:luser9999
  • 2
3 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36576324
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
 

Assisted Solution

by:luser9999
luser9999 earned 0 total points
ID: 36578241
impdp command works for me.....


thanks
0
 

Author Closing Comment

by:luser9999
ID: 36597834
thanks
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Read about achieving the basic levels of HRIS security in the workplace.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now