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: 65144
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: System tablespace resize
Next Topic: how is segment different from object?
Goto Forum:

Current Time: Sat Aug 19 15:44:45 CDT 2017

Total time taken to generate the page: 0.05957 seconds