Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Size of a dump file after import & export

RE: Size of a dump file after import & export

From: Post, David (Corporate) <Dave.Post_at_Staples.com>
Date: Tue, 3 Aug 2004 10:02:12 -0400
Message-ID: <E77431CF9E0AD61198B30002A5F397FB0B8AD00F@fraex24.staples.com>


Three things come to mind that may help. If you have the log file from the 7.2 export see if it contains the schema of interest. Run the import using indexfile=<somefilename>. Strings <<dumpfile>> |grep <<schema name>>. These steps should help determine what is really in the dump file.

Dave

-----Original Message-----

From: Justin Cave [mailto:justin_at_askddbc.com] Sent: Tuesday, August 03, 2004 8:14 AM
To: oracle-l_at_freelists.org
Subject: Size of a dump file after import & export

We came across a 6.5 Gb dump file from Oracle 7.2.3 whose data has recently become useful again. I did a full import into a new 9.2.0.1 database, only to discover that some of the tables (1 schema worth) that were thought to be in the export file didn't get imported. The import log contained no errors relating to those objects other than some invalid views that depended on the missing tables.  

As a sanity check, I figured I would do a full export of the newly imported database, figuring that the new export file should be roughly equivalent in size to the old export file size. Unfortunately, after doing this sanity check, the new export file is only 4.5 Gb. As I see it, that implies that I have either lost 2 Gb worth of data from the original import or something has caused the export file size to shrink.  

At this point, I'm rather hopeful that there exists a logical explanation for the new export file being 30% smaller than the original export that doesn't involve me losing data, but I'll be darned if I can find one. I did import the DMT 7.2.3 tablespaces into LMT tablespaces on the new instance, but I don't see how that would cause this sort of change.  

The import & export commands I'm using  

mp system/<<pwd>>@<<db name>> log=<<dump file>>.log file=<<dump file>>.dmp full=y ignore=y destroy=n constraints=n
exp system/<<pwd>>@<<db name>> full=y file=verify.dmp log=verify.log  

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com  



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Aug 03 2004 - 08:58:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US