Re: Snapshot with a LONG/LONGRAW field

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 30 Jun 1999 14:55:32 -0700
Message-ID: <377A9254.51628FDD@us.oracle.com>

Depends on what version you're running. Oracle7 had a variety of mechanisms to get around this limitation, none of which were very pretty. In Oracle8 you can convert the long columns to equivalent CLOB and BLOB columns, for which replication is supported.

Having said that, I would question the validity of a need to send something that could be 4 Gb in size around the network! :)

HTH. Pete

student wrote:

> Dear readers,
> i am trying to create snapshots for tables which have a LONG column and
> LONGRAW column and i am getting the following error mesg:
> ORA-00997: illegal use of LONG datatype
>
> Any suggestion for this problem will be highly appreciated.
>
> Thanx in advance
>
> EN Nadu
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Wed Jun 30 1999 - 16:55:32 CDT