Re: ALTER TYPE

<Mordashov_at_gmail.com> a écrit dans le message de news: 1150717741.676373.83300_at_c74g2000cwc.googlegroups.com...
|
| > Post a clear test case and copy/paste what you've done.
| > Give your Oracle version.
| > And giving the OS does not hurt.
| Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on Linux
| x86-64
|
| SQL> select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_ID,a.timestamp from
| all_objects a where OBJECT_NAME='FIELD_OBJECT2';
|
| OBJECT_NAME SUBOBJECT_NAME OBJECT_ID TIMESTAMP
| ------------------------------ ------------------------------
| ---------- ------------
| SQL>
|
|
|
| CREATE OR REPLACE TYPE FIELD_OBJECT2 as object (
| descr varchar2 (50),
| field_name varchar2 (32),
| type_id number,
| data_type varchar2 (32) );
| /
| Type created
|
|
| create table TABLE_TEST
| (
| TEST FIELD_OBJECT2
| )
| /
|
| Table created
|
| ALTER TYPE FIELD_OBJECT2 ADD ATTRIBUTE (long_name VARCHAR2(300))
| CASCADE INCLUDING TABLE DATA;
|
| Type altered
|
|
| SQL> select OBJECT_NAME,SUBOBJECT_NAME,OBJECT_ID,a.timestamp from
| all_objects a where OBJECT_NAME='FIELD_OBJECT2';
|
| OBJECT_NAME SUBOBJECT_NAME OBJECT_ID TIMESTAMP
| --------------------------- ------------------------------ ----------
| -------------------
| FIELD_OBJECT2 83221
| 2006-06-19:15:40:48
| FIELD_OBJECT2 $VSN_1 83219
| 2006-06-19:15:40:19
|
|
| There are two versions of my object..I dont need older one, how can I
| drop it?
|

The latest version (and only valid one) is the one were subobject is null. Query user_types/all_types if you want to get all valid types instead of all_objects.

Regards
Michel Cadot Received on Mon Jun 19 2006 - 08:50:31 CDT