How do I copy LONG columns between tables?

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 - 07:54:45 CST