Home » RDBMS Server » Server Utilities » Dump file generation (Oracle 10.2.0.4.0,SunOS)
Dump file generation [message #539794] Wed, 18 January 2012 10:26 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,


I have a question on export dump file generation.

select sum(bytes)/(1024*1024*1024) "GB" from dba_segments where owner='JACK'; 


The above select query give the output of Schema size with 15 GB.

When i perform the same schema export, the dump file size generating is 2 GB.

Can somebody explain the difference between the two scenarios as how come there could be a variation in file size?


Thank you
Re: Dump file generation [message #539795 is a reply to message #539794] Wed, 18 January 2012 10:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Holes in the blocks, not used blocks and Oracle overhead.

Regards
Michel
Re: Dump file generation [message #539797 is a reply to message #539795] Wed, 18 January 2012 10:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
indexes
Re: Dump file generation [message #539798 is a reply to message #539794] Wed, 18 January 2012 10:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And DBA_SEGMENTS will includes all kinds of segments including indexes.
While export will have only index definition which will be used to rebuild during import.
Re: Dump file generation [message #539807 is a reply to message #539797] Wed, 18 January 2012 11:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
BlackSwan wrote on Wed, 18 January 2012 17:34
indexes


Indeed! and in first place...

Regards
Michel

Re: Dump file generation [message #539814 is a reply to message #539807] Wed, 18 January 2012 11:08 Go to previous messageGo to next message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
@Mahesh

Quote:
While export will have only index definition which will be used to rebuild during import.


Very good information, never thought so deeply.
Re: Dump file generation [message #540086 is a reply to message #539814] Fri, 20 January 2012 03:57 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member

Thank you all for your inputs.
Previous Topic: How to import dump into specific tablespace instead of default tablespace users.
Next Topic: IMP-00085
Goto Forum:
  


Current Time: Mon Dec 23 06:39:38 CST 2024