Search: For:
Browsing Single Category
www.dbatoolz.com ORACLE DBA Forums Ask DBA › Question Id: 4003 | Permalink

Dumpfile size

Question ID: 4003
Created By: 2010-APR-15 00:23:16 [Singireddidba]
Updated By: 2010-APR-15 01:47:43 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
11271
2010-APR-15 00:23:16
User
 
 
Registered On: Feb 2010
Total Posts: 24
Hi
i just want to export the table called HR.EMPLOYEES , the table size was 1GB 
and two indexes are associated with that table each one of size is 100MB , i 
want to export the table with indexes also....( 1GB + 100MB + 100MB)
What my question was .....what is the exported dump file size approximately  ,

Thank u 
Bhaskar  
11274
2010-APR-15 01:47:43
Moderator
 
 
Registered On: Mar 2006
Total Posts: 289
The size of the INDEX doesn't have any effect on the export file -- indexes are 
simply exported as SQL statements (CREATE INDEX ...).