Home » RDBMS Server » Server Utilities » How to estimate the size of dump file (Oracle 9.2.0.2.0 , windows)
How to estimate the size of dump file [message #615326] Mon, 02 June 2014 09:13 Go to next message
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 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2457
Registered: May 2013
Location: World Wide on the Web
Senior Member
Search documentation for ESTIMATE parameter.
Re: How to estimate the size of dump file [message #615328 is a reply to message #615327] Mon, 02 June 2014 09:19 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
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
Re: How to estimate the size of dump file [message #615329 is a reply to message #615328] Mon, 02 June 2014 09:28 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2457
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
Re: How to estimate the size of dump file [message #615330 is a reply to message #615329] Mon, 02 June 2014 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
SELECT Round(SUM(bytes) / ( 1024 * 1024 )) MB 
FROM   dba_extents 
WHERE  owner = 'TARGET_SCHEMA' 
       AND segment_type NOT LIKE '%INDEX%'; 
Re: How to estimate the size of dump file [message #615331 is a reply to message #615330] Mon, 02 June 2014 09:52 Go to previous messageGo to next message
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.
Re: How to estimate the size of dump file [message #615332 is a reply to message #615331] Mon, 02 June 2014 10:02 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
>also in 10g and so on.

for V10+ you should be using expdp; not obsoleted exp
Re: How to estimate the size of dump file [message #615392 is a reply to message #615332] Tue, 03 June 2014 04:03 Go to previous messageGo to next message
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.

Re: How to estimate the size of dump file [message #615405 is a reply to message #615392] Tue, 03 June 2014 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 22927
Registered: January 2009
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!
Re: How to estimate the size of dump file [message #615612 is a reply to message #615405] Fri, 06 June 2014 00:05 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Got it Blackswan and will do the same.
Re: How to estimate the size of dump file [message #615613 is a reply to message #615612] Fri, 06 June 2014 00:09 Go to previous message
BlackSwan
Messages: 22927
Registered: January 2009
Senior Member
YOYO!
Previous Topic: Schemas missing in test database
Next Topic: SQL Loader - Unable to load data
Goto Forum:
  


Current Time: Fri Oct 31 07:14:14 CDT 2014

Total time taken to generate the page: 0.10162 seconds