Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

import oracle dump

Posted on 2011-09-21
3
Medium Priority
?
508 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

636 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