| CLOB back to LONG. In 9i possible? [message #63832] |
Sun, 14 November 2004 19:10  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
In 9i, you can change a table's column from LONG to CLOB via an alter table column command.
Can you convert it back using the same method??
Thanks .... IA
|
|
|
|
| Re: CLOB back to LONG. In 9i possible? [message #63836 is a reply to message #63832] |
Sun, 14 November 2004 20:46  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
No, you'll hit an ORA-22859: invalid modification of columns. Oracle recommends to use clobs and blobs instead of longs and long raws. CLOBs can be used in a more intuitive way ( LIKE, instr...).
If you really want to convert a CLOB to a LONG you can either recreate the table with a LONG instead of a CLOB and copy the content. An alternative would be to add the LONG column, copy the CLOB values to the LONG column and drop the CLOB column.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
