RE: converting long to lob - the easiest and fastest way ?

[Siddharth Haldankar]

One more thing my database is 8.1.7, think this alter table modify from long to clob is 9i feature   With Warm Regards Siddharth Haldankar Cisco Systems Inc. ODC Zensar Technologies Ltd. #  : 4128374 [EMAIL PROTECTED] [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Siddharth Haldankar Sent: Thursday, September 11, 2003 3:44 PM To: Multiple recipients of list ORACLE-L Subject: converting long to lob - the easiest and fastest way ?   Hi Gurus,   How do I convert a long datatype to clob datatype. Say Table A No                    number Col1                 long Would like to convert to Table A No                    number Col1                  clob   Alter table A modify (col1 clob); Gives an error as inconsistent datatypes.   Could you give me an example of this with lob_storage_clause.   I would like to convert the existing data in clob type also. The to_lob works only for select statements, cannot go through that pain of table creation.   Thanks in advance.   - Siddharth