Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

what is dump(dmp)

582889Aug 15 2007 — edited Aug 16 2007
I have just started taking Oracle DBA courses.
Can anyone tell me what is dump file(dmp)?

Comments

rodneyli
a dump file is typically the result of an export or datapump export if you are on 10g.
Basically, it allows you to move data from database to database. e.g. you would do an export on database a, then do an import using that dump file on database b.
HTH.
APC
A dump to quote the jargon file is either

"An undigested and voluminous mass of information about a problem or the state of a system, especially one routed to the slowest available output device (compare core dump), and most especially one consisting of hex or octal runes describing the byte-by-byte state of memory, mass storage, or some file. "

or

"A backup."

If you have a file with the suffix .DMP it is more likely to be the second category. On an Oracle server it is quite likely to be the output from an database EXPORT. If it is you should be able to use the IMP to list its contents.

Cheers, APC
111248
With Oracle, you can export data (using exp utility or expdp for 10g+). The file generated has by default a .dmp extension. This file is called export file or dump Oracle. This file (dump) has a binary format (readable only by imp ou impdp if expdp was used).
582889
is it generated only in 10g? or 9i as well
And is it generated only in linux? or windows as well
thanks
rodneyli
Yes, on both versions..
and on all platforms...so, it's one way to transport data across platforms.
586573
Generated with the Oracle EXPORT utility and I believe is avaiable for all platforms and all versions. But if you EXPORT with a 10g version you can not IMPORT the file with a 9i version. However, EXPORTing with 9i and IMPORTing with 10g is good.

Regards
Tim
582889
thanks a lot for your help
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 13 2007
Added on Aug 15 2007
#general-database-discussions
7 comments
342 views