RE: how to modify an object type
- From: "Srinivas T" <SrinivasT@xxxxxxxxxxxxxxx>
- To: <stevenoyle1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 30 Sep 2004 09:52:13 +0530
Hi friends,
I am getting the following error after altering the type...
SQL> desc mytype
ERROR:
ORA-22335: The client cannot work with an altered type
Suggest regarding the same.....
Regards,
Srinivas
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of steve noyle
Sent: Thursday, September 30, 2004 9:41 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: how to modify an object type
hi, I would like to verify the proper way of adding an
attribute to an object type.=20
From the 9i documentation, it appears that I can just
add an attribute directly to an object from the
'create type' syntax but there were a number of notes
on metalink that advise to drop all dependent objects
and recreating the object type. The dependent tables
are huge so I cannot afford the time to drop and
recreate them.=20
Can you verify what would be the proper procedure of
adding an attribute to an object type?=20
SQL> create type mytype as object (name varchar2(50));
2 /
Type created.
SQL> create table mytab (x number, y mytype);
=20
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: 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
