OraFAQ Forum: Server Utilities » How to estimate the size of export dump fille size?

Home » RDBMS Server » Server Utilities » How to estimate the size of export dump fille size?

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

How to estimate the size of export dump fille size? [message #235115]

Fri, 04 May 2007 02:10

orasupport
Messages: 11
Registered: May 2007

Junior Member

Is there any formula / methods to estimate the size of the export dump file without actually running the export?

Thnx,
Jayesh

Report message to a moderator

Re: How to estimate the size of export dump fille size? [message #235122 is a reply to message #235115]

Fri, 04 May 2007 02:24

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Yes, you can use the “ESTIMATE ONLY” command to see how much disk space is required for the job’s dump file set before you start the operation.

Report message to a moderator

Re: How to estimate the size of export dump fille size? [message #235134 is a reply to message #235115]

Fri, 04 May 2007 02:53

orasupport
Messages: 11
Registered: May 2007

Junior Member

I think ESTIMATE_ONLY is available only with data pump or 10g.
I am looking for something in Oracle 8i/9i.

Report message to a moderator

Re: How to estimate the size of export dump fille size? [message #235150 is a reply to message #235115]

Fri, 04 May 2007 03:21

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

Senior Member
Account Moderator

Have a look at Metalink note 106465.1: "How to Estimate Export File Size Without Creating Dump File".

But this runs the export but does not create the dump file.
There is no way without this run.

Regards
Michel

Report message to a moderator

Previous Topic:	Passing parameters to a .ctl file
Next Topic:	how to load data from Ms Access to oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 12:27:21 CST 2024