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

Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to alter a table with 'long' data type

Re: Trying to alter a table with 'long' data type

From: Vladimir Vuksan <vuksan-usenet_at_veus.hr>
Date: Fri, 25 Aug 2000 15:17:40 -0700
Message-ID: <8o6om3$1lbm$1@lynx.unm.edu>

In article <8lou1u$1tpa$1_at_s2.feed.news.oleane.net>, "Michel Cadot" <micadot_at_netcourrier.com> wrote:
> You can't change LONG to CLOB, you have to create a new table or a new
> column and use TO_LOB function:
>
> CREATE TABLE long_table (n NUMBER, long_col LONG); CREATE TABLE lob_table (n
> NUMBER, lob_col CLOB); INSERT INTO lob_table
> SELECT n, TO_LOB(long_col) FROM long_table;

If I do the above I get following error message :-(

SELECT ACCNO,TO_LOB(TEXT)

                          *
ERROR at line 3:
ORA-00904: invalid column name       

Any clues why ?

Vladimir Received on Fri Aug 25 2000 - 17:17:40 CDT

Original text of this message

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