OraFAQ Forum: Server Utilities » How to estimate the size of dump file

Home » RDBMS Server » Server Utilities » How to estimate the size of dump file (Oracle 9.2.0.2.0 , windows)

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

How to estimate the size of dump file [message #615326]

Mon, 02 June 2014 09:13

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

I would like to perform schema export using original export.
My schema size is nearly 50G.
How to know how much space the export dump will occupy before running schema export?

Thanks,
jack

[Updated on: Mon, 02 June 2014 09:14]

Report message to a moderator

Re: How to estimate the size of dump file [message #615327 is a reply to message #615326]

Mon, 02 June 2014 09:15

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Search documentation for ESTIMATE parameter.

Report message to a moderator

Re: How to estimate the size of dump file [message #615328 is a reply to message #615327]

Mon, 02 June 2014 09:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Lalit Kumar B wrote on Mon, 02 June 2014 07:15

Search documentation for ESTIMATE parameter.

on V9.2 exp?????????????? I don't think so

Report message to a moderator

Re: How to estimate the size of dump file [message #615329 is a reply to message #615328]

Mon, 02 June 2014 09:28

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

BlackSwan wrote on Mon, 02 June 2014 19:49

on V9.2 exp?????????????? I don't think so

Oops! Didn't notice. Thanks for pointing it out.

V9.2 still in use Shocked

Report message to a moderator

Re: How to estimate the size of dump file [message #615330 is a reply to message #615329]

Mon, 02 June 2014 09:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT Round(SUM(bytes) / ( 1024 * 1024 )) MB 
FROM   dba_extents 
WHERE  owner = 'TARGET_SCHEMA' 
       AND segment_type NOT LIKE '%INDEX%';

Report message to a moderator

Re: How to estimate the size of dump file [message #615331 is a reply to message #615330]

Mon, 02 June 2014 09:52

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Not only in 9.2 version but also in 10g and so on.

Blackswan,

Thanks for the query though.

Report message to a moderator

Re: How to estimate the size of dump file [message #615332 is a reply to message #615331]

Mon, 02 June 2014 10:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>also in 10g and so on.

for V10+ you should be using expdp; not obsoleted exp

Report message to a moderator

Re: How to estimate the size of dump file [message #615392 is a reply to message #615332]

Tue, 03 June 2014 04:03

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,
<for V10+ you should be using expdp; not obsoleted exp>

Yes i am aware of it .Just wanted to know the answer because we are using 9i database as well for development purpose.

Report message to a moderator

Re: How to estimate the size of dump file [message #615405 is a reply to message #615392]

Tue, 03 June 2014 08:51

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Yes i am aware of it .Just wanted to know the answer because we are using 9i database as well for development purpose.
Oracle development version should be identical to Oracle Production version; not higher & not lower version!

Report message to a moderator