Home » RDBMS Server » Server Utilities » Estimate FlatFile Size (Oracle 11.1.0.7)
Estimate FlatFile Size [message #584092] Wed, 08 May 2013 10:26 Go to next message
deepa_balu
Messages: 73
Registered: March 2005
Member
Hi,

We are planning to export the table data to a file pipedelimited.
How do i estimate the size of the FlatFile based on the table size? or avg rowlength

Please help.
Re: Estimate FlatFile Size [message #584093 is a reply to message #584092] Wed, 08 May 2013 10:36 Go to previous messageGo to next message
BlackSwan
Messages: 21982
Registered: January 2009
Senior Member
>How do i estimate the size of the FlatFile based on the table size? or avg rowlength
What is the estimated size for each of the two methodologies?

Using exp or expdp?
Re: Estimate FlatFile Size [message #584094 is a reply to message #584093] Wed, 08 May 2013 10:50 Go to previous messageGo to next message
deepa_balu
Messages: 73
Registered: March 2005
Member
I will be using Sqlplus to exprot the table Data to flatfile
Re: Estimate FlatFile Size [message #584099 is a reply to message #584092] Wed, 08 May 2013 11:57 Go to previous message
Michel Cadot
Messages: 57650
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sum the maximum length of each column add the number of columns and multiply the result by the number of rows.

Regards
Michel
Previous Topic: Databaseimport error
Next Topic: Job "SYSTEM"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error
Goto Forum:
  


Current Time: Thu Apr 24 22:10:10 CDT 2014

Total time taken to generate the page: 0.13090 seconds