Re: Oracle 8i : Recordlength truncated to 65535

1. Don't use "recordlength". Record length was to be specified on the operating systems that have distinguished between fixed record length files and variable record length files, like VMS and MVS. There was to be a whole philosophy around record lengths and locking. Your OS, easily identifiable by the string "C:\" in your commands doesn't do that.
2. You need a bigger buffer. Buffer=10485760 should do the trick. May the force be with you.

On Mon, 26 May 2003 09:36:58 +0200, Mike Smith wrote:

> 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

-- 
Mladen Gogala
Software is like sex, it is better when it is free.
Linus Torvalds