Re: objects

From: Jens Hartwig <jhartwig_at_debis.com>
Date: Tue, 07 Mar 2000 13:20:10 +0100
Message-ID: <38C4F3FA.49ABD0D9@debis.com>

Hello Simon,

there exists a Data Dictionary View, called "USER_OBJECTS". It is defined as following:

OBJECT_NAME         VARCHAR2(128)       Name of the object
SUBOBJECT_NAME      VARCHAR2(30)        Name of the sub-object (for
example, partition)
OBJECT_ID           NUMBER              Object number of the object
DATA_OBJECT_ID      NUMBER              Object number of the segment
which contains the object
OBJECT_TYPE         VARCHAR2(15)        Type of the object (eg, TABLE,
INDEX)
CREATED             DATE                Timestamp for the creation of
the object
LAST_DDL_TIME       DATE                Timestamp of the last DDL
command applied to the object (including grants and revokes)
TIMESTAMP           VARCHAR2(19)        Timestamp for the creation of
the object (character data)
STATUS              VARCHAR2(7)         Status of the object: VALID,
INVALID
TEMPORARY           VARCHAR2(1)         Can the current session only see
data that it place in this object itself?
GENERATED           VARCHAR2(1)         Was the name of this object
system generated?
SECONDARY           VARCHAR2(1)         Is this a secondary object

created as part of create for domain indexes?

Querying this view should solve your problem:

SELECT object_name, object_type, status FROM user_objects;

simon cunningham schrieb:
>
> Does anyone know what the pl/sql command is to view what objects you
> have created in your schema.
>
> Thanks

Regards, Jens Hartwig

---

Jens Hartwig

---

debis Systemhaus GEI mbH
10875 Berlin

Tel.     : +49 (0)30 2554-3282
Fax      : +49 (0)30 2554-3187
Mail     : jhartwig_at_debis.com
=============================================

Please consider: The statements expressed in this mail do represent the authors opinion and are not necessarily identical with those of debis Systemhaus GEI.

---

Received on Tue Mar 07 2000 - 06:20:10 CST