select
x.kglsttyp,
x.kglstdsc,
v.namespace
from
x$kglst x full outer join
v$librarycache v on x.kglstdsc = v.namespace
order by
coalesce(x.kglstdsc, v.namespace);
--
-- TYP_ KGL_NAME NAMESPACE
-- ---------- ----------------------------------------- ----------------------------------------------------------------
-- NAMESPACE ACCOUNT_STATUS ACCOUNT_STATUS
-- NAMESPACE ACL
-- TYPE ACL
-- TYPE APP CAPTURE STATE
-- NAMESPACE APP CONTEXT
-- TYPE APP CONTEXT
-- TYPE APP REPLAY STATE
-- NAMESPACE APP STATE APP STATE
-- TYPE ASSEMBLY
-- NAMESPACE ATTRIBUTE DIMENSION
-- NAMESPACE AUDIT POLICY AUDIT POLICY
-- TYPE AUDIT POLICY AUDIT POLICY
-- NAMESPACE BODY BODY
-- NAMESPACE CLUSTER CLUSTER
-- TYPE CLUSTER CLUSTER
-- NAMESPACE CMP CMP
-- TYPE CMP CMP
-- NAMESPACE CONTEXT FTABLE
-- TYPE CONTEXT FTABLE
-- NAMESPACE CONTEXT MTABLE
-- TYPE CONTEXT MTABLE
-- NAMESPACE CONTEXT MVDATA
-- TYPE CONTEXT MVDATA
-- NAMESPACE CONTEXT POLICY
-- TYPE CONTEXT POLICY OBJECT
-- TYPE CURSOR
-- TYPE CURSOR STATS
-- NAMESPACE DATA SECURITY DOCUMENT
-- TYPE DATA SECURITY DOCUMENT
-- NAMESPACE DBINSTANCE DBINSTANCE
-- NAMESPACE DBLINK DBLINK
-- TYPE DBLINK DBLINK
-- NAMESPACE DIMENSION
-- TYPE DIMENSION
-- NAMESPACE DIRECTORY DIRECTORY
-- TYPE DIRECTORY DIRECTORY
-- NAMESPACE Data_Redaction_Policy_Expression
-- TYPE Data_Redaction_Policy_Expression
-- NAMESPACE Data_Redaction_Policy_Expression_ID
-- NAMESPACE Database Vault Factor
-- TYPE Database Vault Factor
-- NAMESPACE Database Vault Realm Participant
-- TYPE Database Vault Realm Participant
-- NAMESPACE Database Vault Rule
-- TYPE Database Vault Rule
-- NAMESPACE Database Vault Ruleset
-- TYPE Database Vault Ruleset
-- NAMESPACE EDITION EDITION
-- TYPE EDITION EDITION
-- NAMESPACE EV BASE TABLE
-- NAMESPACE FED APP
-- TYPE FED APP
-- TYPE FUNCTION
-- NAMESPACE FUSION NAMESPACE TEMPLATES
-- TYPE FUSION NAMESPACE TEMPLATES
-- NAMESPACE FUSION XS PARAMETERS
-- TYPE FUSION XS PARAMETERS
-- NAMESPACE GENERIC CONTEXT LOADING
-- NAMESPACE GTT SESSION PRIVATE STATS
-- NAMESPACE HINTSET OBJECT HINTSET OBJECT
-- TYPE HINTSET OBJECT HINTSET OBJECT
-- NAMESPACE IFS SCHEMA
-- NAMESPACE INDEX INDEX
-- TYPE INDEX INDEX
-- TYPE INDEX INDEX
-- TYPE INDEX ORGANIZED TABLE
-- TYPE INDEX PARTITION
-- TYPE INDEX SUBPARTITION
-- NAMESPACE INMEMORY SERVICE METADATA
-- TYPE INMEMORY SERVICE METADATA
-- NAMESPACE INMEMORY TS SERVICE METADATA
-- TYPE INMEMORY TS SERVICE METADATA
-- TYPE JAVA CLASS
-- NAMESPACE JAVA DATA
-- TYPE JAVA JAR
-- NAMESPACE JAVA RESOURCE
-- TYPE JAVA RESOURCE
-- TYPE JAVA SHARED DATA
-- NAMESPACE JAVA SOURCE
-- TYPE JAVA SOURCE
-- TYPE JOB RESOURCE
-- TYPE JSFW
-- TYPE KGL TEST
-- NAMESPACE KGL TESTING
-- NAMESPACE KGLNEDSYNC
-- NAMESPACE KZP Exempt Access Policy list
-- TYPE KZP Exempt Access Policy list
-- NAMESPACE LABEL SECURITY COMPARTMENT NO->SHORT NAME
-- TYPE LABEL SECURITY COMPARTMENT NO->SHORT NAME
-- NAMESPACE LABEL SECURITY COMPARTMENT SHORT NAME->NO
-- TYPE LABEL SECURITY COMPARTMENT SHORT NAME->NO
-- NAMESPACE LABEL SECURITY GROUP NO->SHORT NAME
-- TYPE LABEL SECURITY GROUP NO->SHORT NAME
-- NAMESPACE LABEL SECURITY GROUP SHORT NAME->NO
-- TYPE LABEL SECURITY GROUP SHORT NAME->NO
-- NAMESPACE LABEL SECURITY ILABELS
-- TYPE LABEL SECURITY ILABELS
-- NAMESPACE LABEL SECURITY LEVEL NO->SHORT NAME
-- TYPE LABEL SECURITY LEVEL NO->SHORT NAME
-- NAMESPACE LABEL SECURITY LEVEL SHORT NAME->NO
-- TYPE LABEL SECURITY LEVEL SHORT NAME->NO
-- NAMESPACE LABEL SECURITY OLS$AUDIT
-- TYPE LABEL SECURITY OLS$AUDIT
-- TYPE LABEL SECURITY PROFILE DATA LABELS
-- NAMESPACE LABEL SECURITY PROFILE DATALABELS
-- NAMESPACE LABEL SECURITY USERS
-- TYPE LABEL SECURITY USERS
-- TYPE LIBRARY
-- NAMESPACE LIGHT WEIGHT SESSION
-- TYPE LIGHT WEIGHT SESSION
-- NAMESPACE LOB
-- TYPE LOB
-- TYPE LOB PARTITION
-- TYPE LOB SUBPARTITION
-- NAMESPACE LOCATION
-- TYPE LOCATION
-- NAMESPACE LOCKDOWN
-- TYPE LOCKDOWN
-- NAMESPACE Last_Successful_Logon_Time
-- NAMESPACE MINING MODEL
-- TYPE MINING MODEL
-- TYPE MINING MODEL PARTITION
-- NAMESPACE MULTI-VERSION OBJECT FOR CLUSTER
-- NAMESPACE MULTI-VERSION OBJECT FOR INDEX
-- NAMESPACE MULTI-VERSION OBJECT FOR TABLE
-- TYPE MULTI-VERSIONED OBJECT
-- TYPE NON-EXISTENT
-- TYPE OBJECT
-- NAMESPACE OBJECT ID OBJECT ID
-- TYPE OBJECT ID OBJECT ID
-- TYPE OLAP ANALYTIC VIEW
-- TYPE OLAP BUILD PROCESS
-- TYPE OLAP CUBE
-- TYPE OLAP CUBE DIMENSION
-- TYPE OLAP HIERARCHY
-- TYPE OLAP HIERARCHY DIMENSION
-- TYPE OLAP MEASURE FOLDER
-- TYPE OPERATOR
-- NAMESPACE OPTIMIZER DIRECTIVE OWNER
-- NAMESPACE OPTIMIZER EXPRESSION HEADER
-- NAMESPACE OPTIMIZER EXPRESSION OBJECT
-- NAMESPACE OPTIMIZER FINDING
-- TYPE Optimizer Directive Owner
-- TYPE Optimizer Expresion Object
-- TYPE Optimizer Expression Header
-- TYPE Optimizer Finding
-- TYPE PACKAGE
-- TYPE PACKAGE BODY
-- NAMESPACE PCINDX
-- NAMESPACE PCTABL
-- NAMESPACE PDB PDB
-- TYPE PDB PDB
-- NAMESPACE PDBOPER
-- NAMESPACE PENDING RESOURCE MANAGER CONSUMER GROUP
-- TYPE PENDING RESOURCE MANAGER CONSUMER GROUP
-- NAMESPACE PENDING RESOURCE MANAGER PLAN
-- TYPE PENDING RESOURCE MANAGER PLAN
-- NAMESPACE PIPE
-- TYPE PIPE
-- TYPE PROCEDURE
-- TYPE PTNC
-- NAMESPACE PUB SUB INTERNAL INFORMATION
-- TYPE PUB SUB INTERNAL INFORMATION
-- NAMESPACE QUEUE QUEUE
-- TYPE QUEUE QUEUE
-- NAMESPACE QUEUE SUBSCRIBER
-- TYPE QUEUE SUBSCRIBER
-- NAMESPACE REMOTE OBJECT INFORMATION
-- TYPE REMOTE OBJECT INFORMATION
-- NAMESPACE REMOTE OBJECT LOCAL SUMMARY REFERENCE
-- TYPE REMOTE OBJECT LOCAL SUMMARY REFERENCE
-- NAMESPACE REPLICATED TABLE OBJECT
-- TYPE REPLICATED TABLE OBJECT
-- NAMESPACE REPLICATION - LOG BASED CHILD
-- NAMESPACE REPLICATION DESTINATION
-- NAMESPACE REPLICATION INTERNAL PACKAGE
-- TYPE REPLICATION INTERNAL PACKAGE
-- NAMESPACE REPLICATION OBJECT GROUP
-- TYPE REPLICATION OBJECT GROUP
-- NAMESPACE REPLICATION PROPAGATOR
-- TYPE REPLICATION PROPAGATOR
-- NAMESPACE REPLICATION SOURCE
-- NAMESPACE RESOURCE MANAGER
-- NAMESPACE RESOURCE MANAGER CDB
-- TYPE RESOURCE MANAGER CDB PLAN
-- TYPE RESOURCE MANAGER CONSUMER GROUP
-- TYPE RESOURCE MANAGER PLAN
-- NAMESPACE RULE
-- TYPE RULE
-- NAMESPACE RULE EVALUATION CONTEXT
-- TYPE RULE EVALUATION CONTEXT
-- NAMESPACE RULESET RULESET
-- TYPE RULESET RULESET
-- NAMESPACE RUNTIME STATISTICS
-- TYPE RUNTIME STATISTICS
-- TYPE SCHEDULER CHAIN
-- TYPE SCHEDULER CLASS
-- TYPE SCHEDULER CREDENTIAL
-- TYPE SCHEDULER DESTINATION
-- NAMESPACE SCHEDULER EVENT QUEUE INFORMATION
-- TYPE SCHEDULER EVENT QUEUE INFORMATION
-- NAMESPACE SCHEDULER GLOBAL ATTRIBUTE
-- TYPE SCHEDULER GLOBAL ATTRIBUTE
-- TYPE SCHEDULER GROUP
-- TYPE SCHEDULER IN-MEMORY JOB
-- TYPE SCHEDULER JOB
-- NAMESPACE SCHEDULER JOB SLAVE
-- TYPE SCHEDULER JOB SLAVE
-- NAMESPACE SCHEDULER LIGHTWEIGHT JOB
-- TYPE SCHEDULER LIGHTWEIGHT JOB
-- TYPE SCHEDULER PROGRAM
-- TYPE SCHEDULER SCHEDULE
-- TYPE SCHEDULER WINDOW
-- NAMESPACE SCHEMA SCHEMA
-- NAMESPACE SCRATCH PAD
-- TYPE SCRATCH PAD
-- NAMESPACE SDO GeoRaster SysData Cache
-- TYPE SDO GeoRaster SysData Cache
-- NAMESPACE SDO Geom MetaData
-- TYPE SDO Geom MetaData
-- NAMESPACE SDO Index MetaData
-- TYPE SDO Index MetaData
-- NAMESPACE SDO Product Usage
-- TYPE SDO Product Usage
-- NAMESPACE SDO Row Cache
-- TYPE SDO Row Cache
-- NAMESPACE SDO SRID CRS DIM
-- TYPE SDO SRID CRS DIM
-- NAMESPACE SDO SRID MetaData
-- TYPE SDO SRID MetaData
-- NAMESPACE SECURITY CLASS
-- NAMESPACE SECURITY CLASS
-- TYPE SECURITY CLASS
-- TYPE SECURITY CLASS
-- NAMESPACE SECURITY PROFILE
-- TYPE SEQUENCE
-- NAMESPACE SNAPSHOT META DATA
-- TYPE SNAPSHOT METADATA
-- TYPE SOURCE IN LOG BASED REPLICATION
-- NAMESPACE SQL AREA SQL AREA
-- NAMESPACE SQL AREA BUILD SQL AREA BUILD
-- NAMESPACE SQL AREA STATS SQL AREA STATS
-- NAMESPACE SQL TRANSLATION CACHE
-- TYPE SQL TRANSLATION CACHE
-- NAMESPACE SQL TRANSLATION PROFILE
-- TYPE SQL TRANSLATION PROFILE
-- NAMESPACE SQL TUNING BASE OBJECT
-- TYPE SQL TUNING BASE OBJECT
-- NAMESPACE STORED OUTLINE
-- TYPE STORED OUTLINE
-- NAMESPACE STREAM
-- NAMESPACE STREAMS APPLY PROCESS
-- TYPE STREAMS APPLY PROCESS
-- TYPE STREAMS CAPTURE PROCESS
-- TYPE STREAMS DDL
-- TYPE STREAMS FILE GROUP
-- NAMESPACE STREAMS PROPOGATION
-- TYPE STREAMS PROPOGATION
-- TYPE STUB OBJECT
-- NAMESPACE SUBSCRIPTION
-- TYPE SUBSCRIPTION
-- NAMESPACE SUMMARY
-- TYPE SUMMARY
-- NAMESPACE SYNC STREAMS CAPTURE
-- TYPE SYNONYM
-- TYPE TABLE
-- TYPE TABLE PARTITION
-- TYPE TABLE SUBPARTITION
-- NAMESPACE TABLE/PROCEDURE TABLE/PROCEDURE
-- NAMESPACE TEMPORARY CLUSTER
-- NAMESPACE TEMPORARY INDEX TEMPORARY INDEX
-- NAMESPACE TEMPORARY TABLE TEMPORARY TABLE
-- NAMESPACE TRANSFORMATION
-- TYPE TRANSFORMATION
-- NAMESPACE TRIGGER TRIGGER
-- TYPE TRIGGER TRIGGER
-- TYPE TYPE
-- TYPE TYPE BODY
-- TYPE USER
-- NAMESPACE USER AGENT
-- NAMESPACE USER PRIVILEGE USER PRIVILEGE
-- TYPE USER PRIVILEGES
-- TYPE VIEW
-- NAMESPACE XDB ACL
-- NAMESPACE XDB CONFIG
-- NAMESPACE XDB REPOSITORY
-- TYPE XDB REPOSITORY
-- TYPE XDB SCHEMA DATA
-- NAMESPACE XDBTM
-- NAMESPACE XDBTM ID2NS
-- NAMESPACE XDBTM ID2PATH
-- NAMESPACE XDBTM ID2QNAME
-- NAMESPACE XDBTM NS2ID
-- NAMESPACE XDBTM PATH2ID
-- NAMESPACE XDBTM QNAME2ID
-- NAMESPACE XML SCHEMA XML SCHEMA
-- NAMESPACE ZLL nlil
-- TYPE ZLL nlil
-- NAMESPACE ZLL policy-table
-- TYPE ZLL policy-table
-- NAMESPACE ZLLR pol# to table-list
-- TYPE ZLLR pol# to table-list
302 rows selected.