DBA_OBJECTS


SQL> DESC DBA_OBJECTS

 Name                                     Null?    Type
 ------------------------------------------------- ----------------------------
 OWNER                                             VARCHAR2(30)
 OBJECT_NAME                                       VARCHAR2(128)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 OBJECT_ID                                         NUMBER
 DATA_OBJECT_ID                                     NUMBER
 OBJECT_TYPE                                       VARCHAR2(19)
 CREATED                                            DATE
 LAST_DDL_TIME                                      DATE
 TIMESTAMP                                         VARCHAR2(19)
 STATUS                                            VARCHAR2(7)
 TEMPORARY                                         VARCHAR2(1)
 GENERATED                                         VARCHAR2(1)
 SECONDARY                                         VARCHAR2(1)
 NAMESPACE                                         NUMBER
 EDITION_NAME                                      VARCHAR2(30)

No comments:

Post a Comment