Xref: alice comp.databases.oracle.misc:19686
Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!news.demon.co.uk!demon!johncrane.demon.co.uk!not-for-mail
From: "Doug Hughes" <doug.hughes@johncrane.co.uk>
Newsgroups: comp.databases.oracle.misc
Subject: Copying records that have a LONG field
Date: Wed, 9 Sep 1998 12:39:41 +0100
Message-ID: <905341193.5972.0.nnrp-01.c2de8277@news.demon.co.uk>
X-Trace: news.demon.co.uk 905341193 nnrp-01:5972 NO-IDENT johncrane.demon.co.uk:194.222.130.119
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Lines: 17

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