buffer parameter in export and import
|
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