Re: Oracle 8i : Recordlength truncated to 65535

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Mon, 26 May 2003 19:38:56 +1000
Message-ID: <3ed1e0d7$0$8986$afc38c87@news.optusnet.com.au>

"Mike Smith" <mike121_at_hotmail.com> wrote in message news:3ed1c41a$0$11123$ba620e4c_at_reader0.news.skynet.be...

> 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 ?
>

It's just a warning. AFAIK, the important parameter for LONGs is BUFFER. RECORDLENGTH is just used as a physical record size for writing to the export file. If a row is longer, it will just span records.

Set your BUFFER to the largest a LONG will be and let it rip, should work.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Mon May 26 2003 - 04:38:56 CDT