Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00997: illegal use of LONG datatype (Oracle 10g)
ORA-00997: illegal use of LONG datatype [message #569202] Mon, 22 October 2012 12:58 Go to next message
Chessaficionado
Messages: 4
Registered: October 2012
Location: Atlanta
Junior Member
Please help ..

When trying to create a temo table on a Database with :
create table
tkl_186523_temp as select * from tkl where tkl_cd = 'ACSCL' AND
ENTRY_DT >= '14-SEP-2012' AND INS_BY = 'CRTVRAM';

I'm getting an ERROR at line 2:
ORA-00997: illegal use of LONG datatype


Re: ORA-00997: illegal use of LONG datatype [message #569204 is a reply to message #569202] Mon, 22 October 2012 13:03 Go to previous messageGo to next message
joy_division
Messages: 4454
Registered: February 2005
Location: East Coast USA
Senior Member
1. You cannot do a CTAS from a table that has a LONG datatype just as the error message says
2. ENTRY_DT >= '14-SEP-2012' is poor coding as you are "probably" comparing a DATE column to a character string.
Re: ORA-00997: illegal use of LONG datatype [message #569735 is a reply to message #569204] Wed, 31 October 2012 14:06 Go to previous message
Chessaficionado
Messages: 4
Registered: October 2012
Location: Atlanta
Junior Member
Thanks for the response and my apologies in the delayed response.
Previous Topic: A better way to check every table for data?
Next Topic: Sample Extraction
Goto Forum:
  


Current Time: Thu Apr 24 16:31:37 CDT 2014

Total time taken to generate the page: 0.12089 seconds