Home » RDBMS Server » Server Utilities » Evaluate export dump size (Oracle 10.2.0.4.0,SunOS)
Evaluate export dump size [message #539058] Wed, 11 January 2012 03:32 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
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
Re: Evaluate export dump size [message #539070 is a reply to message #539060] Wed, 11 January 2012 04:06 Go to previous messageGo to next message
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
Re: Evaluate export dump size [message #539073 is a reply to message #539070] Wed, 11 January 2012 04:11 Go to previous messageGo to next message
cookiemonster
Messages: 11076
Registered: September 2008
Location: Rainy Manchester
Senior Member
How are you measuring the size of the schema?
Re: Evaluate export dump size [message #539074 is a reply to message #539073] Wed, 11 January 2012 04:15 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
select sum(bytes)/(1024*1024*1024) "GB" from dba_segments where owner='JACK';
Re: Evaluate export dump size [message #539091 is a reply to message #539070] Wed, 11 January 2012 04:55 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
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

Re: Evaluate export dump size [message #539108 is a reply to message #539091] Wed, 11 January 2012 05:58 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member

Thank you michel
Previous Topic: SQL Loader is not uploading non-ASCII characters
Next Topic: EXPDP problem
Goto Forum:
  


Current Time: Sat Oct 25 05:25:10 CDT 2014

Total time taken to generate the page: 0.04976 seconds