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
maninderkrb
Messages: 41
Registered: August 2012
Location: India
Member

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
LKBrwn_DBA
Messages: 425
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: 58573
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.

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


Current Time: Fri Jul 25 20:53:36 CDT 2014

Total time taken to generate the page: 0.07978 seconds