Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: changing long to lob

RE: changing long to lob

From: Jon Walthour <jonw_at_fuse.net>
Date: Mon, 20 Aug 2001 18:34:39 -0700
Message-ID: <F001.00371BAB.20010820181027@fatcity.com>

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 Mon Aug 20 2001 - 20:34:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US