Copying records that have a LONG field

From: Doug Hughes <doug.hughes_at_johncrane.co.uk>
Date: Wed, 9 Sep 1998 12:39:41 +0100
Message-ID: <905341193.5972.0.nnrp-01.c2de8277@news.demon.co.uk>

I'm trying to copy selected records from one table to another. The records contain a LONG field.

It would seem that there is no way to do this, as it's not possible to include a LONG field in the SELECT sub-query, i.e.

INSERT INTO Table1 (SELECT * FROM Table2 WHERE Clause);

gives the Oracle error ORA-00997 if Table2 contains a LONG field.

Is this an impossible quest? Is there really no way to do this? Any help appreciated.

Doug Hughes Received on Wed Sep 09 1998 - 06:39:41 CDT