LONG column restricts CREATE/INSERT using SELECT clause

From: Melisa Mrazik <mmrazik>
Date: 1996/05/15
Message-ID: <4nd6v0$7s4_at_spruce.citicorp.com>#1/1

We are currently running Oracle 7.1.4 on HP-UX 9.0 I was trying to copy a table in a user's schema with the following command: CREATE TABLE error2 AS SELECT * FROM error1; and recieved an ORA-00997 error on a LONG datatype

I also tried to create table error2 and then use the following command: INSERT INTO error2 SELECT * FROM error1;  and recieved the same error.

Oracle support has told me that I can either use PL/SQL to convert the LONG to a VARCHAR2 column to successfully copy (not an option as the group wants to keep the LONG column) or to use the COPY command. However, the analyst was not able to tell me _why_ I can't copy from one table to another when a LONG column is in the original table. Apparently, this isn't a bug so can anyone tell me what's wrong with this statement?

TIA,
Melisa Mrazik

---

|Melisa Mrazik, Systems Officer | "I quote others only in |
|Citicorp, N.A. Westlake, TX | order to better express |
|melisa.mrazik_at_citicorp.com | myself." -Michel de Montaigne|
Received on Wed May 15 1996 - 00:00:00 CEST