Can you verify what would be the proper procedure of
adding an attribute to an object type?
SQL > create type mytype as object (name varchar2(50));
2 /
Type created.
SQL > create table mytab (x number, y mytype);
Table created.
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;
Type altered.
SQL > desc mytype
Name Null? Type
-- ---- ---- ------ -- ----- -- ------
NAME VARCHAR2(50)
ADDRESS VARCHAR2(50)
Also, what would be the query to list all the
dependent objects? I was not able to find it in
user_object_tables.
SQL > select * from user_object_tables;
no rows selected
TIA
Steve
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
