Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Trying to alter a table with 'long' data type
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