DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.DBA_LIBRARIES

Object Details
Object Name: DBA_LIBRARIES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of all libraries in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the library
LIBRARY_NAME VARCHAR2 (128) Yes Name of the library
FILE_SPEC VARCHAR2 (2000)
Operating system file specification of the library
DYNAMIC VARCHAR2 (1)
Is the library dynamically loadable
STATUS VARCHAR2 (7)
Status of the library
AGENT VARCHAR2 (128)
Agent of the library
LEAF_FILENAME VARCHAR2 (2000)
Leaf filename of the library
ORIGIN_CON_ID NUMBER

ID of Container where row originates
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      LIBRARY_NAME
,      FILE_SPEC
,      DYNAMIC
,      STATUS
,      AGENT
,      LEAF_FILENAME
,      ORIGIN_CON_ID
FROM SYS.DBA_LIBRARIES;

Dependencies

[top of page]

SYS.DBA_LIBRARIES references the following:

SchemaSYS
ViewINT$DBA_LIBRARIES
SYS.DBA_LIBRARIES is referenced by following:

SchemaPUBLIC
SynonymDBA_LIBRARIES
SchemaSYS
ProcedureXOQ_VALIDATE - show dependent code