Oracle dump (.dmp) file format

oracle format rdbms dmp
Luis Andrés García picture Luis Andrés García · Nov 16, 2012 · Viewed 7.6k times · Source

I am wondering about how is the internal format of a .dmp file (dump file, or backup and restoration file) used by Oracle RBMS.

Does it follow any standard? Is it optimized in any way?

Thanks.

Edited:

Oracle version: 11g

Answer

a_horse_with_no_name picture a_horse_with_no_name · Nov 16, 2012

Does it follow any standard.

Yes - the one that Oracle defined for their export format.

It it optimized in any way

You can compress the data, if that's what you mean.
See the manual for details: http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#BABCAJHC

Related questions

Oracle SQL - DATE greater than statement

As the title says, I want to find a way to check which of my data sets are past 6 months from SYSDATE via query. SELECT * FROM OrderArchive WHERE OrderDate <= '31 Dec 2014'; I've tried the following but it returns …

Read More
Why do i get #### in the NUMBER column after format... Oracle?

I have two problematic columns: Fee NUMBER type, AdjFee also NUMBER. After column Fee format a5; select Fee ID smth from Visit; i get Fee ID smth #### 123 klkl #### 654 rfjgr

Read More
Oracle sqlldr timestamp format headache

I'm struggling to get sqlldr to import a csv data file into my table, specifically with the field that is a timestamp. The data in my csv file is in this format: 16-NOV-09 01.57.48.001000 PM I've tried all manner of combinations …

Read More