Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i : Recordlength truncated to 65535
Hi,
I have a problem with importing a dump file from Oracle 7 in Oracle 8i : I get a warning that the recordlength is being truncated to 65535. This is a problem because in the database there is a field of type LONG RAW. The data in this field > 65535 bytes.
What can I do to solve this problem ?
The export script for Oracle 7 (7.03.02) :
c:\orant\bin\exp73 AAA/BBB_at_database BUFFER=200000 file=d:\dbbackup\database.dmp FULL=Y LOG=d:\dbbackup\database.log RECORDLENGTH=200000 The import script for Oracle 8i (8.1.7) :
IMP USERID=AAA/BBB_at_database FULL=Y BUFFER=200000 RECORDLENGTH=200000 COMMIT=Y FILE=d:\dbbackup\database.dmp GRANTS=Y IGNORE=Y LOG=IMP.LOG
The warning at import :
Import: Release 8.1.7.0.0
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Note: RECORDLENGTH=200000 truncated to 65535
Connected to: Oracle8i Release 8.1.7.0.0 - Production JServer Release 8.1.7.0.0 - Production
Export file created by EXPORT:V07.03.02 via conventional path . importing SYSTEM's objects into SYSTEM ...
TIA, Mike Received on Mon May 26 2003 - 02:36:58 CDT