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

buffer parameter in export and import

Question ID: 4043
Created By: 2010-JUN-09 05:42:43 [Swathigo]
Updated By: 2010-JUN-09 12:45:51 [Vitaliy]
Status: Open
Severity: Normal
Read Only: No
11472
2010-JUN-09 05:42:43
User
 
 
Registered On: Feb 2010
Total Posts: 25
Hi Vitaliy

While exporting and importing tables, i have read that buffer parameter plays a 
very important role and should be sized accordingly. But how do we calculate 
which value is suitable for this 

Regards
SWathi
11474
2010-JUN-09 12:45:51
Moderator
 
 
Registered On: Mar 2006
Total Posts: 292
SWathi,

You'll know when you need to set the buffer to a higher value because the 
import will fail with small buffer.  For example it can happen when importing 
large tables (multiple partitions, etc..).  Don't worry too much about it -- 
you'll know when you need to size it larger.  It's a trial and error thing.  
I've used buffer=12582912 with good results (on import).

- Vitaliy