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 -> adding attribute to type with dependency

adding attribute to type with dependency

From: emoracle <vanmeerendonk_at_gmail.com>
Date: 18 Jul 2006 04:18:34 -0700
Message-ID: <1153221514.197186.77100@b28g2000cwb.googlegroups.com>


I have the following scenario
drop table t_c
/

drop type t_a
/

create type t_a as object (kol_a number)
/

create table t_c (kol_c1 number, kol_c2 t_a)
/

So, I have a type t_a that is referenced by a table t_c.

And now i want to add a attribute to t_a without dropping table t_c. How do I do that?

In 9i+ we have ALTER TYPE xx ADD ATTRIBUTE but not in 8.1.7

I can't drop and recreate t_a, because there are dependent objects (t_c).

I'm at a loss. Received on Tue Jul 18 2006 - 06:18:34 CDT

Original text of this message

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