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


VIEW: SYS.CDB_LIBRARIES

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

Description of all libraries in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the library
LIBRARY_NAME VARCHAR2 (30) 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_LIBRARIES;

Dependencies

[top of page]

SYS.CDB_LIBRARIES does not reference any database object

SYS.CDB_LIBRARIES is referenced by following:

SchemaPUBLIC
SynonymCDB_LIBRARIES