Importing dmp file

10 pts.
Tags:
DMP Importing
Oracle import/export
What is the procedure for importing a dmp file?
ASKED: April 20, 2009  7:47 PM
UPDATED: July 22, 2009  9:13 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

This<a href=”http://searchoracle.techtarget.com/loginMembersOnly/1,289498,sid41_gci905149,00.html?NextURL=http%3A//searchoracle.techtarget.com/news/article/0%2C289142%2Csid41_gci905149%2C00.html%3FExclusive%3DTrue”> tip has some good i</a>nfo. You have to register but its free
%0

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Inprise
    Hi, You can use import(imp) in case of 9i else import data pump in case of 10g YOu should identify wat way the export dump is generated using imp or impdp Here is the syntax For import grant unlimited tablespace to ZZZZZZZ ZZZZZ == can be list of schemas to be imported imp file= XXXX.dmp log=aaaa.log full=y Here XXXX - dump file aaaa - log name full =y represents all schemas For import datapump impdp directory=data_pump_dir dumpfile=XXXX.dmp logfile=aaa.log Regards Inprise
    610 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following