RE: changing long to lob

[Jon Walthour]

Title: Message

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 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of JOE TESTA Sent: Monday, August 20, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Subject: 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