OraFAQ Forum: Server Utilities » Evaluate export dump size

Home » RDBMS Server » Server Utilities » Evaluate export dump size (Oracle 10.2.0.4.0,SunOS)

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

Evaluate export dump size [message #539058]

Wed, 11 January 2012 03:32

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I want to take a schema level export .The schema size is 115 GB size .Can somebody tell me do we require
same amount of space to be available in server side (where we are taking a dump) as the schema size
or less or more space is required in server side ?

Thank you

[Updated on: Wed, 11 January 2012 03:35]

Report message to a moderator

Re: Evaluate export dump size [message #539060 is a reply to message #539058]

Wed, 11 January 2012 03:36

Michel Cadot
Messages: 67137
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No one can say.
It depends on what you mean by "The schema size is 115 GB size" and how the space is used in the schema (empty blocks and block filling ratio).

Regards
Michel

Report message to a moderator

Re: Evaluate export dump size [message #539070 is a reply to message #539060]

Wed, 11 January 2012 04:06

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

But the pre - requisite before taking a export is

1.Verify the space availability in server before taking a export.
2.Verify the user having enough privileges for export.

Based on the above conditions only , i asked these questions.

Thank you

Report message to a moderator

Re: Evaluate export dump size [message #539073 is a reply to message #539070]

Wed, 11 January 2012 04:11

cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester

Senior Member

How are you measuring the size of the schema?

Report message to a moderator

Re: Evaluate export dump size [message #539074 is a reply to message #539073]

Wed, 11 January 2012 04:15

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

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

Report message to a moderator

Re: Evaluate export dump size [message #539091 is a reply to message #539070]

Wed, 11 January 2012 04:55

Michel Cadot
Messages: 67137
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Jack14 wrote on Wed, 11 January 2012 11:06

But the pre - requisite before taking a export is

1.Verify the space availability in server before taking a export.
2.Verify the user having enough privileges for export.

Based on the above conditions only , i asked these questions.

Thank you

But no one can answer.
If you use Data Pump, you can use the ESTIMATE_ONLY option to get the size.

Regards
Michel

Report message to a moderator

Re: Evaluate export dump size [message #539108 is a reply to message #539091]

Wed, 11 January 2012 05:58

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thank you michel

Report message to a moderator

Previous Topic:	SQL Loader is not uploading non-ASCII characters
Next Topic:	EXPDP problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 30 01:45:12 CDT 2020