ILLEGAL USE OF LONG DATATYPE?

From: Jay Valdez <jay_at_dontspamme.com>
Date: Mon, 7 Jan 2002 09:10:41 -0800
Message-ID: <5Ik_7.1814$N9.4277@news.bc.tac.net>

INSERT INTO TRAININGPROGRAMS_TEST SELECT * FROM TRAININGPROGRAMS Error-->ILLEGAL USE OF LONG DATATYPE.

Oracle 8.1.7

Hello, I was wondering why this would occur in this situation.

This is the DDL

CREATE TABLE TRAININGPROGRAMS (
  TYPEID NUMBER NOT NULL,
  PROGRAMNAME VARCHAR2 (255),
  DESCRIPTION LONG,
  TIMEINDEX DATE DEFAULT SYSDATE,   PRIMARY KEY ( TYPEID ) ) ; CREATE TABLE TRAININGPROGRAMS_TEST (
  TYPEID NUMBER NOT NULL,
  PROGRAMNAME VARCHAR2 (255),
  DESCRIPTION LONG,
  TIMEINDEX DATE DEFAULT SYSDATE,   PRIMARY KEY ( TYPEID ) ) ; Received on Mon Jan 07 2002 - 11:10:41 CST