Home » RDBMS Server » Server Administration » long data type illegal?
long data type illegal? [message #573326] Wed, 26 December 2012 14:46 Go to next message
Messages: 41
Registered: August 2012
Location: India

when I try comnd
create table a as select * from b where 1=2;
it says illegal datatype long
i m bemused what sin has the long datatype done?
Re: long data type illegal? [message #573327 is a reply to message #573326] Wed, 26 December 2012 14:56 Go to previous messageGo to next message
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Oracle® Database SQL Language Reference: LONG Data Type

Do not create tables with LONG columns. Use LOB columns (CLOB, NCLOB, BLOB) instead. LONG columns are supported only for backward compatibility.

[Updated on: Wed, 26 December 2012 15:09] by Moderator

Report message to a moderator

Re: long data type illegal? [message #573328 is a reply to message #573326] Wed, 26 December 2012 15:11 Go to previous message
Michel Cadot
Messages: 64729
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LONG datatypes are obsolete since more than 15 years.
Do you still use Windows 95 on your PC?
Anyone that still uses LONG datatype just deserves the hell where they are.

Previous Topic: Monitoring alerts and logs.
Next Topic: users creation limits
Goto Forum:

Current Time: Thu Apr 27 16:10:32 CDT 2017

Total time taken to generate the page: 0.13977 seconds