Specifies the size, in bytes, of the buffer used to fetch rows. As a result, this parameter determines the maximum number of rows in an array fetched by Export.
Use the following formula to calculate the buffer size:
buffer_size = rows_in_array * maximum_row_size
If you specify zero, the Export utility fetches only one row at a time.
Tables with columns of typeLONG,LOB,BFILE,REF,ROWID,LOGICALROWID, or
DATE are fetched one row at a time.
Example: Calculating Buffer Size
This section shows an example of how to calculate buffer size.
The following table is created:
CREATE TABLE sample (name varchar(30), weight number);
The maximum size of thename column is 30, plus 2 bytes for the indicator. The
maximum size of theweight column is 22 (the size of the internal representation for Oracle numbers), plus 2 bytes for the indicator.
Therefore, the maximum row size is 56 (30+2+22+2).
To perform array operations for 100 rows, a buffer size of 5600 should be specified.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-968359/，如需转载，请注明出处，否则将追究法律责任。