Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.25 DBA_OBJECTS

The DBA_OBJECTS view provides information about all objects in the database.

Name

Type

Description

owner

VARCHAR2

User name of the object’s owner.

schema_name

VARCHAR2

Name of the schema in which the object belongs.

object_name

VARCHAR2

Name of the object.

object_type

VARCHAR2

Type of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.

status

VARCHAR2

Included for compatibility only; always set to VALID.

temporary

TEXT

Y if the table is temporary; N if the table is permanent.

Previous PageTable Of ContentsNext Page