Re: 10g - Column Conversion: Varchar2 to CLOB

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 Jul 2007 06:06:21 -0700
Message-ID: <1185887179.508721@bubbleator.drizzle.com>

Craig wrote:
> DA Morgan wrote:

>> May help depending on precisely what you are doing.

>
> Convert VARCHAR2 Column to NCLOB Column

Given this:

SQL> CREATE TABLE t (

   2 testcol VARCHAR2(20));

Table created.

SQL> INSERT INTO t VALUES ('ABC');

1 row created.

SQL> COMMIT; Commit complete.

SQL> ALTER TABLE t MODIFY (testcol NCLOB); ALTER TABLE t MODIFY (testcol NCLOB)

                       *

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

If you want help then perhaps you should try a different tact.

YOYO.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 31 2007 - 08:06:21 CDT