Re: Inserting LONG RAW into a table

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 - 20:30:30 CEST