Re: ALTER TYPE

From: <Mordashov_at_gmail.com>
Date: 19 Jun 2006 04:49:01 -0700
Message-ID: <1150717741.676373.83300@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? Received on Mon Jun 19 2006 - 06:49:01 CDT