Re: ORA-00997: Annoying LONG/LONG RAW columns when alter table .. move tablespace

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00997: Annoying LONG/LONG RAW columns when alter table .. move tablespace

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 25 Sep 2006 14:05:49 -0700
Message-ID: <1159218349.391740.189650@m7g2000cwm.googlegroups.com>

NitelyJoy wrote:
> Why are PLAN_TABLEs (created by file
> $ORACLE_HOME/rdbms/admin/utlxplan.sql) for Oracle 9i (what about 10g? I
> don't know.) still created with a LONG column, when this data type is
> deprecated since Oracle 8?

Because oracle is not completely consistent yet in terms of dealing with LONGs.

>
> If I convert the LONG column of all PLAN TABLEs with the function
> to_lob() on my own, is that way supported and desired by Oracle?

Dunno probably not. Open a service request if that is something you really plan to try.

>
> Why does Oracle not provide a create statement with a LOB column
> instead in utlxplan.sql?

Good question why don't you submit that in a service request? Received on Mon Sep 25 2006 - 16:05:49 CDT