| long data type illegal? [message #573326] |
Wed, 26 December 2012 14:46  |
 |
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 #573454 is a reply to message #573452] |
Fri, 28 December 2012 12:51  |
 |
LKBrwn_DBA
Messages: 362
Registered: July 2003
Location: WPB, FL
|
Senior Member |
|
|
msol25 wrote on Fri, 28 December 2012 13:32
Please ignore to use Long datatype,Instead you can use CLOB Datatype.You can also assign values to long datatype as i have used in oracle 8i,but you need to create xml and save into particular unix location and then call that file using sqlldr,then you will able to load that .xml file into particular long datatype column.But i think u can't assign directly to long datatype as it is depricated before 8i as well.
Dear mumbai,
What are you talking about?
[Updated on: Fri, 28 December 2012 12:53] by Moderator Report message to a moderator |
|
|
|
] 
Members
Search
Help
Register
Login
Home
