oracle imp buffer参数,[20171105]exp imp buffer参数解析.txt

[20171105]exp imp buffer参数解析.txt

oracle官方所给的关于buffer的解释如下：

BUFFER

Default: operating system-dependent. See your Oracle operating system-specific documentation to determine the default

value for this parameter.

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, then the Export utility fetches only one row at a time.

Tables with columns of type LOBs, LONG, BFILE, REF, ROWID, LOGICAL ROWID, or DATE are fetched one row at a time.

Note:

The BUFFER parameter applies only to conventional path Export. It has no effect on a direct path Export. For direct path

Exports, use the RECORDLENGTH parameter to specify the