Re: How do I copy LONG columns between tables?

http://osi.oracle.com/~tkyte has an article about accomplishing this using the *sqlplus* (so not sql) COPY command.

Hth,

Sybrand Bakker, Oracle DBA

"Stefan Larsson" <d95stela+news_at_dtek.chalmers.se> wrote in message news:slrn91ssp5.srr.d95stela+news_at_licia.dtek.chalmers.se...
> Hi!
>
> I have run across a few problems when using the LONG datatype in
> Oracle 7.3.4.
>
> I have two tables:
>
> CREATE TABLE Elements1
> id_ INTEGER,
> elt_ LONG
> );
>
> and Elements2 which looks exactly the same.
>
> Oracle won't let me copy data between the tables with
> statements like
>
> INSERT INTO Elements2
> SELECT id_, elt_ FROM Elements1;
>
> because the LONG datatype is not allowed in insert select lists,
> in fact, the LONG datatype seems to be disallowed almost everywhere.
>
> What solutions exists? Should I use a table with varchar entries instead?
>
> /stefan
Received on Fri Nov 24 2000 - 12:00:56 CST