ITPub博客

首页 > 应用开发 > IT综合 > Export Parameter : Buffer

Export Parameter : Buffer

原创 IT综合 作者:tsinglee 时间:2007-09-07 14:32:23 0 删除 编辑

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.

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-968359/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1897914