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


VIEW: SYS.USER_LIBRARIES

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

Description of the user's own libraries

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 LIBRARY_NAME
,      FILE_SPEC
,      DYNAMIC
,      STATUS
,      AGENT
,      LEAF_FILENAME
,      ORIGIN_CON_ID
FROM SYS.USER_LIBRARIES;

Dependencies

[top of page]

SYS.USER_LIBRARIES references the following:

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

SchemaPUBLIC
SynonymUSER_LIBRARIES