OraFAQ Forum: Server Utilities » Dump file generation

Home » RDBMS Server » Server Utilities » Dump file generation (Oracle 10.2.0.4.0,SunOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dump file generation [message #539794]

Wed, 18 January 2012 10:26

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

Report message to a moderator

Re: Dump file generation [message #539795 is a reply to message #539794]

Wed, 18 January 2012 10:27

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Holes in the blocks, not used blocks and Oracle overhead.

Regards
Michel

Report message to a moderator

Re: Dump file generation [message #539797 is a reply to message #539795]

Wed, 18 January 2012 10:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

indexes

Report message to a moderator

Re: Dump file generation [message #539798 is a reply to message #539794]

Wed, 18 January 2012 10:35

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.

Report message to a moderator