RE: changing long to lob

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 21 Aug 2001 05:29:59 -0700
Message-ID: <F001.003720D6.20010821052048@fatcity.com>

Jon, sorry it was a 9i thing.
 

joe
>>> jonw_at_fuse.net 08/20/01 10:10PM
>>>
Joe:
 

Can you tell me if you were able to do this? I just tried it and it errored out on me:
 

SQL> create
table test_lob (col1 varchar2(30), col_lob long);
 

Table
created.
 

SQL> desc

test_lob Name                                      
Null?    Type ----------------------------------------- 

---

---------------------------- COL1                                               
VARCHAR2(30) COL_LOB                                            

LONG
 

SQL> alter table
test_lob modify col_lob clob;alter table test_lob modify col_lob

clob                            

*ERROR at line 1:ORA-22858: invalid alteration of datatype
 

Thanks,
 

Jon
Walthour   

  <FONT
  face=Tahoma>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com] On Behalf Of JOE TESTASent:   Monday, August 20, 2001 4:26 PMTo: Multiple recipients of list   ORACLE-LSubject: changing long to lob
  while looking thru the migration guide(for downgrade info in case it   happens),
   
  alter table <table_name> modify <long_col> clob;    
  and supposedly POOF its now a clob.
   
  interesting.
   
  joe
    Received on Tue Aug 21 2001 - 07:29:59 CDT