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: ORA-00997: Annoying LONG/LONG RAW columns when alter table .. move tablespace

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

From: NitelyJoy <nitelyjoy_at_ist-einmalig.de>
Date: 25 Sep 2006 12:46:33 -0700
Message-ID: <1159213593.549535.235250@m73g2000cwd.googlegroups.com> 





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?



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?



Why does Oracle not provide a create statement with a LOB column
instead in utlxplan.sql?
Received on Mon Sep 25 2006 - 14:46:33 CDT












Original text of this message













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