0 pts.
 export RECORDLENGTH
I was runing an export against an 8.1.6.3 database the other day, and got the following informational message: Note: RECORDLENGTH=1048576 truncated to 65535 I was wondering what the significance of this message is. The number 65536 happens to be the setting for SORT_AREA_SIZE. Thanks.

Software/Hardware used:
ASKED: May 12, 2004  10:45 AM
UPDATED: May 12, 2004  11:13 AM

Answer Wiki:
From the 8.1.7 Utilities Manual, the chapter on Export RECORDLENGTH Default: operating system-dependent Specifies the length, in bytes, of the file record. The RECORDLENGTH parameter is necessary when you must transfer the export file to another operating system that uses a different default value. If you do not define this parameter, it defaults to your platform-dependent value for BUFSIZ. For more information about the BUFSIZ default value, see your operating system-specific documentation. You can set RECORDLENGTH to any value equal to or greater than your system's BUFSIZ. (The highest value is 64KB.) Changing the RECORDLENGTH parameter affects only the size of data that accumulates before writing to the disk. It does not affect the operating system file block size. Note: You can use this parameter to specify the size of the Export I/O buffer. Additional Information: See your Oracle operating system-specific documentation to determine the proper value or to create a file with a different record size.
Last Wiki Answer Submitted:  May 12, 2004  11:13 am  by  Jrmills   0 pts.
All Answer Wiki Contributors:  Jrmills   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

It has nothing to do with the value of SORT_AREA_SIZE. The max value for this export parameter is 65535.

 0 pts.