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: 74
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.

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
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?

Report message to a moderator

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: 74
Registered: March 2005
Member
I will be using Sqlplus to exprot the table Data to flatfile

Report message to a moderator

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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 01:31:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.