Re: Inserting LONG RAW into a table

Hi Rose,
Well, you can use the COPY command of SQL*Plus utility, like this:

sql> set long MAXIMUM_LONG_OF_YOUR_COLUMN_LONG_RAW; sql> copy from username/password create TARGET_TABLE using select * from SOURCE_TABLE; Juan Carlos Rodriguez
D.B.A.

Rose Noel Kamene <rkamene_at_easynet.co.uk> wrote in article <7h1s2u$25vc$1_at_quince.news.easynet.net>...
> 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.
>
>
>
Received on Tue May 11 1999 - 07:08:31 CDT