Re: Question about objects whose object

From: <Winnie_Liu_at_infonet.com>
Date: Tue, 16 May 2000 16:23:46 -0700
Message-Id: <10499.105797@fatcity.com>

These are the object "TYPE" created by the create type SQL statement.

Check Oracle documentation for the application development guide for more info about "TYPE"

Winnie

"Guang Mei" <zlmei_at_hotmail.com> on 05/16/2000 12:36:45 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC)

Subject: Question about objects whose object_type='TYPE'

Hi:

I have a question about oracle object whose type ='TYPE'. I did the following query to our oracle db:

SQLWKS> select * from all_objects where object_type='TYPE'
     2> and owner='CATPROD2'
     3>
OWNER                          OBJECT_NAME
SUBOBJECT_NAME
                 OBJECT_ID  DATA_OBJEC OBJECT_TYPE        CREATED
LAST_DDL_ TIMESTAMP           STATUS  T G S
------------------------------ ------------------------------
------------------------------ ---------- ---------- ------------------
--------- --------- ------------------- ------- - - -
CATPROD2                       HPXCHARTAB
                      33332            TYPE               27-APR-00
27-APR-00 2000-01-28:12:27:51 VALID   N N N
CATPROD2                       HPXSTRINGLIST
                      33333            TYPE               27-APR-00

27-APR-00 2000-02-28:12:03:28 VALID N N N 2 rows selected.

Does anyone know how probably these two objects get created? How to find more info about "TYPE" objects? I thought they might get created when store procedures (with the same name) were created, but I am not positive. We already dropped the store procedures.

Thanks.

Guang

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Author: Guang Mei
  INET: zlmei_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue May 16 2000 - 18:23:46 CDT

Re: Question about objects whose object_type='TYPE'