Re: Inserting LONG RAW into a table

From: Dante <dnotari_at_my-dejanews.com>
Date: Sat, 08 May 1999 18:30:30 GMT
Message-ID: <7h1vs8$s88$1@nnrp1.deja.com>

Rose,
you could this by exporting the users tables (with the exp utility) and import it (with the imp utility) into your schema.

Oracle 8 introduced a new set of datatypes: the LOBs ... this new datatype makes your life a lot easier and does not have all the restrictions LONG ROW has.

Regards
Dante
In article <7h1s2u$25vc$1_at_quince.news.easynet.net>, "Rose Noel Kamene" <rkamene_at_easynet.co.uk> wrote:
> Hello everybody,
> I am trying to create a table identical to one owned by another user.
> The original table ( y ) has a LONG RAW column so when I use the following
> statement , I get an error message.
> << CREATE TABLE x AS SELECT * FROM y ; >>
> Can someone please help work round this problem.
> Regards
> RNK.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat May 08 1999 - 13:30:30 CDT