Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i : Recordlength truncated to 65535

Oracle 8i : Recordlength truncated to 65535

From: Mike Smith <mike121_at_hotmail.com>
Date: Mon, 26 May 2003 09:36:58 +0200
Message-ID: <3ed1c41a$0$11123$ba620e4c@reader0.news.skynet.be>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US