SQL > create or replace type mytype as object (name
varchar2(50), address varchar2(50));
2 /
create or replace type mytype as object (name
varchar2(50), address varchar2(50));
*
ERROR at line 1:
ORA-02303 (See ORA-02303.ora-code.com): cannot drop or replace a type with type or
table dependents
SQL > alter type mytype add attribute (address
varchar2(50)) cascade;
=20
Type altered.
=20
SQL > desc mytype
Name Null? Type
-- ---- ---- ------ -- ----- -- ------=20
NAME VARCHAR2(50)
ADDRESS VARCHAR2(50)
=20
Also, what would be the query to list all the
dependent objects? I was not able to find it in
user_object_tables.=20
SQL > select * from user_object_tables;
=20
no rows selected
TIA
Steve
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around=20
http://mail.yahoo.com=20
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
