Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba objects
Содержание
Get all system packages
SQL>
SQL> select object_name
2 from dba_objects
3 where owner = "SYS"
4 and object_type = "PACKAGE";
OBJECT_NAM
----------
STANDARD
DBMS_STAND
ARD
DBMS_REGIS
TRY
442 rows selected.
Get the creation time and updated time for dba objects
SQL>
SQL>
SQL> COLUMN object_name FORMAT a25
SQL> COLUMN created FORMAT a20
SQL> COLUMN updated FORMAT a20
SQL> SELECT object_name, object_type,
2 TO_CHAR(created, "MM/DD/YY HH24:MI:SS") created,
3 TO_CHAR(last_ddl_time, "MM/DD/YY HH24:MI:SS") updated
4 FROM dba_objects
5 WHERE object_type IN ("PACKAGE","PACKAGE BODY", "PROCEDURE",
6 "FUNCTION", "TRIGGER")
7 AND OWNER = "PLSQL_USER"
8 and rownum < 50
9 ORDER BY object_name;
no rows selected
SQL>
List all sys owned package name
SQL> select object_name
2 from dba_objects
3 where owner = "SYS"
4 and object_type = "PACKAGE";
Enter...
STANDARD
DBMS_STANDARD
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
XML_SCHEMA_NAME_PRESENT
UTL_RAW
DBMS_ADVISOR
PLITBLM
SYS_STUB_FOR_PURITY_ANALYSIS
PIDL
DIANA
DIUTIL
DBMS_PICKLER
DBMS_JAVA_TEST
UTL_FILE
UTL_TCP
UTL_INADDR
UTL_SMTP
UTL_HTTP
UTL_URL
UTL_ENCODE
Enter...
UTL_GDK
DBMS_LOB
UTL_SYS_COMPRESS
UTL_COMPRESS
UTL_I18N
UTL_LMS
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_SPACE_ADMIN
DBMS_TYPES
DBMS_TRANSACTION
DBMS_SESSION
DBMS_UTILITY
DBMS_ROWID
DBMS_PCLXUTIL
DBMS_ERRLOG
DBMS_ASSERT
DBMS_SPACE
DBMS_TRANSACTION_INTERNAL_SYS
DBMS_APPLICATION_INFO
DBMS_LOCK
442 rows selected.
Query dba_objects by owner
SQL>
SQL>
SQL> SELECT * FROM dba_objects WHERE owner="SYSTEM" and rownum<50;
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
SYSTEM
SYSCATALOG
2563 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
CATALOG
2565 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
TAB
2567 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:05 VALID N N N
SYSTEM
COL
2570 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
TABQUOTAS
2574 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
SYSFILES
2576 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
PUBLICSYN
2579 SYNONYM 07-FEB-06 07-FEB-06
2006-02-07:22:12:06 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD
3621 3621 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:23 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD_PK
3622 3622 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_WORKLOAD_IDX_01
3623 3623 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_BASETABLE
3624 3624 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_BASETABLE_IDX_01
3625 3625 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_SQLDEPEND
3626 3626 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_SQLDEPEND_IDX_01
3627 3627 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_PRETTY
3628 3628 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_PRETTY_IDX_01
3629 3629 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_TEMP
3630 3630 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_TEMP_IDX_01
3631 3631 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTER
3632 3632 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTER_PK
3633 3633 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LOG
3634 3634 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LOG_PK
3635 3635 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FILTERINSTANCE
3636 3636 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LEVEL
3637 3637 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_LEVEL_PK
3638 3638 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_ROLLUP
3639 3639 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_ROLLUP_PK
3640 3640 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_AJG
3641 3641 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_AJG_PK
3642 3642 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FJG
3643 3643 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_FJG_PK
3644 3644 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:24 VALID N N N
SYSTEM
MVIEW$_ADV_GC
3645 3645 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_GC_PK
3646 3646 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_CLIQUE
3647 3647 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_CLIQUE_PK
3648 3648 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_ELIGIBLE
3649 3649 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_ELIGIBLE_PK
3650 3650 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_OUTPUT
3651 3651 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ---------- -------------- ------------------- --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
MVIEW$_ADV_OUTPUT_PK
3652 3652 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_EXCEPTIONS
3653 3653 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PARAMETERS
3654 3654 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PARAMETERS_PK
3655 3655 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_INFO
3656 3656 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_INFO_PK
3657 3657 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_JOURNAL
3658 3658 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_JOURNAL_PK
3659 3659 INDEX 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADV_PLAN
3660 3660 TABLE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADVSEQ_GENERIC
3661 SEQUENCE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
SYSTEM
MVIEW$_ADVSEQ_ID
3662 SEQUENCE 07-FEB-06 07-FEB-06
2006-02-07:22:13:25 VALID N N N
49 rows selected.
SQL>
SQL>
Query dba_objects for owner name and object type
SQL>
SQL> SELECT object_name
2 from dba_objects
3 WHERE owner = "SYS"
4 AND object_type = "PACKAGE"
5 ORDER BY object_name;
OBJECT_NAME
--------------------------------------------------------------------------------
DBMSHSXP
DBMSOBJG
DBMSOBJG2
DBMSOBJGWRAPPER
DBMSOBJG_DP
DBMSZEXP_SYSPKGGRNT
DBMS_ADVANCED_REWRITE
DBMS_ADVISOR
DBMS_ALERT
DBMS_APPCTX
DBMS_APPLICATION_INFO
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_APPLY_ADM
DBMS_APPLY_ADM_INTERNAL
DBMS_APPLY_ERROR
DBMS_APPLY_PROCESS
DBMS_APPLY_USER_AGENT
DBMS_AQ
DBMS_AQADM
DBMS_AQADM_SYS
DBMS_AQADM_SYSCALLS
DBMS_AQELM
DBMS_AQIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AQJMS
DBMS_AQJMS_INTERNAL
DBMS_AQ_BQVIEW
DBMS_AQ_EXP_CMT_TIME_TABLES
DBMS_AQ_EXP_HISTORY_TABLES
DBMS_AQ_EXP_INDEX_TABLES
DBMS_AQ_EXP_QUEUES
DBMS_AQ_EXP_QUEUE_TABLES
DBMS_AQ_EXP_SIGNATURE_TABLES
DBMS_AQ_EXP_SUBSCRIBER_TABLES
DBMS_AQ_EXP_TIMEMGR_TABLES
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AQ_EXP_ZECURITY
DBMS_AQ_IMPORT_INTERNAL
DBMS_AQ_IMP_INTERNAL
DBMS_AQ_IMP_ZECURITY
DBMS_AQ_INV
DBMS_AQ_SYS_EXP_ACTIONS
DBMS_AQ_SYS_EXP_INTERNAL
DBMS_AQ_SYS_IMP_INTERNAL
DBMS_ASH_INTERNAL
DBMS_ASSERT
DBMS_ASYNCRPC_PUSH
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_AW
DBMS_AW_EXP
DBMS_BACKUP_RESTORE
DBMS_CAPTURE_ADM
DBMS_CAPTURE_ADM_INTERNAL
DBMS_CAPTURE_PROCESS
DBMS_CHANGE_NOTIFICATION
DBMS_CLR
DBMS_CRYPTO
DBMS_CRYPTO_FFI
DBMS_CRYPTO_TOOLKIT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_CRYPTO_TOOLKIT_FFI
DBMS_CRYPTO_TOOLKIT_TYPES
DBMS_DATAPUMP
DBMS_DATAPUMP_UTL
DBMS_DBLINK
DBMS_DBVERIFY
DBMS_DB_VERSION
DBMS_DDL
DBMS_DDL_INTERNAL
DBMS_DEBUG
DBMS_DEBUG_JDWP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DEBUG_JDWP_CUSTOM
DBMS_DEFER
DBMS_DEFERGEN
DBMS_DEFERGEN_AUDIT
DBMS_DEFERGEN_INTERNAL
DBMS_DEFERGEN_LOB
DBMS_DEFERGEN_PRIORITY
DBMS_DEFERGEN_RESOLUTION
DBMS_DEFERGEN_UTIL
DBMS_DEFERGEN_WRAP
DBMS_DEFER_ENQ_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DEFER_IMPORT_INTERNAL
DBMS_DEFER_INTERNAL_QUERY
DBMS_DEFER_INTERNAL_SYS
DBMS_DEFER_QUERY
DBMS_DEFER_QUERY_UTL
DBMS_DEFER_REPCAT
DBMS_DEFER_SYS
DBMS_DEFER_SYS_PART1
DBMS_DESCRIBE
DBMS_DIMENSION
DBMS_DISTRIBUTED_TRUST_ADMIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_DRS
DBMS_EPG
DBMS_ERRLOG
DBMS_EXPORT_EXTENSION
DBMS_EXTENDED_TTS_CHECKS
DBMS_FBT
DBMS_FEATURE_USAGE
DBMS_FEATURE_USAGE_INTERNAL
DBMS_FEATURE_USAGE_REPORT
DBMS_FGA
DBMS_FILE_GROUP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_FILE_GROUP_DECL
DBMS_FILE_GROUP_EXP
DBMS_FILE_GROUP_EXP_INTERNAL
DBMS_FILE_GROUP_IMP
DBMS_FILE_GROUP_IMP_INTERNAL
DBMS_FILE_GROUP_INTERNAL_INVOK
DBMS_FILE_GROUP_UTL
DBMS_FILE_GROUP_UTL_INVOK
DBMS_FILE_TRANSFER
DBMS_FLASHBACK
DBMS_FREQUENT_ITEMSET
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_HA_ALERTS
DBMS_HA_ALERTS_PRVT
DBMS_HS
DBMS_HS_ALT
DBMS_HS_CHK
DBMS_HS_UTL
DBMS_IAS_CONFIGURE
DBMS_IAS_INST
DBMS_IAS_INST_UTL
DBMS_IAS_INST_UTL_EXP
DBMS_IAS_MT_INST
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_IAS_MT_INST_INTERNAL
DBMS_IAS_QUERY
DBMS_IAS_SESSION
DBMS_IAS_TEMPLATE
DBMS_IAS_TEMPLATE_INTERNAL
DBMS_IAS_TEMPLATE_UTL
DBMS_IJOB
DBMS_INDEX_UTL
DBMS_INTERNAL_LOGSTDBY
DBMS_INTERNAL_REPCAT
DBMS_INTERNAL_SAFE_SCN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_INTERNAL_TRIGGER
DBMS_IREFRESH
DBMS_ISCHED
DBMS_ISCHED_CHAIN_CONDITION
DBMS_ISNAPSHOT
DBMS_ITRIGGER_UTL
DBMS_I_INDEX_UTL
DBMS_JAVA_DUMP
DBMS_JAVA_TEST
DBMS_JOB
DBMS_LCR
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_LDAP
DBMS_LDAP_API_FFI
DBMS_LDAP_UTL
DBMS_LOB
DBMS_LOCK
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_INTERNAL
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_SESSION
DBMS_LOGREP_DEF_PROC_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_LOGREP_EXP
DBMS_LOGREP_IMP
DBMS_LOGREP_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
DBMS_LOGSTDBY
DBMS_MAINT_GEN
DBMS_METADATA
DBMS_METADATA_BUILD
DBMS_METADATA_DPBUILD
DBMS_METADATA_INT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_METADATA_UTIL
DBMS_MONITOR
DBMS_OBFUSCATION_TOOLKIT
DBMS_OBFUSCATION_TOOLKIT_FFI
DBMS_ODCI
DBMS_OFFLINE_INTERNAL
DBMS_OFFLINE_OG
DBMS_OFFLINE_RGT
DBMS_OFFLINE_SNAPSHOT
DBMS_OFFLINE_UTL
DBMS_OUTPUT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_PCLXUTIL
DBMS_PICKLER
DBMS_PIPE
DBMS_PITR
DBMS_PLUGTS
DBMS_PLUGTSP
DBMS_PREPROCESSOR
DBMS_PROFILER
DBMS_PROPAGATION_ADM
DBMS_PROPAGATION_INTERNAL
DBMS_PRVTAQIM
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_PRVTAQIP
DBMS_PRVTAQIS
DBMS_PRVTRMIE
DBMS_PRVT_TRACE
DBMS_PSP
DBMS_PSWMG_IMPORT
DBMS_RANDOM
DBMS_RCVMAN
DBMS_RECOVERABLE_SCRIPT
DBMS_RECO_SCRIPT_INT
DBMS_RECO_SCRIPT_INVOK
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RECTIFIER_DIFF
DBMS_RECTIFIER_FRIENDS
DBMS_REDEFINITION
DBMS_REFRESH
DBMS_REFRESH_EXP_LWM
DBMS_REFRESH_EXP_SITES
DBMS_REGISTRY
DBMS_REGISTRY_SERVER
DBMS_REGISTRY_SYS
DBMS_REGXDB
DBMS_REPAIR
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT
DBMS_REPCAT_ADD_MASTER
DBMS_REPCAT_ADMIN
DBMS_REPCAT_AUTH
DBMS_REPCAT_CACHE
DBMS_REPCAT_COMMON_UTL
DBMS_REPCAT_CONF
DBMS_REPCAT_DECL
DBMS_REPCAT_EXP
DBMS_REPCAT_FLA
DBMS_REPCAT_FLA_MAS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_FLA_UTL
DBMS_REPCAT_INSTANTIATE
DBMS_REPCAT_INTERNAL
DBMS_REPCAT_INTERNAL_PACKAGE
DBMS_REPCAT_MAS
DBMS_REPCAT_MIG
DBMS_REPCAT_MIGRATION
DBMS_REPCAT_MIG_INTERNAL
DBMS_REPCAT_OBJ_UTL
DBMS_REPCAT_OUTPUT
DBMS_REPCAT_RGT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_RGT_ALT
DBMS_REPCAT_RGT_CHK
DBMS_REPCAT_RGT_CUST
DBMS_REPCAT_RGT_CUST2
DBMS_REPCAT_RGT_EXP
DBMS_REPCAT_RGT_UTL
DBMS_REPCAT_RPC
DBMS_REPCAT_RPC_UTL
DBMS_REPCAT_RQ
DBMS_REPCAT_SNA
DBMS_REPCAT_SNA_UTL
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_REPCAT_SQL_UTL
DBMS_REPCAT_UNTRUSTED
DBMS_REPCAT_UTL
DBMS_REPCAT_UTL2
DBMS_REPCAT_UTL3
DBMS_REPCAT_UTL4
DBMS_REPCAT_VALIDATE
DBMS_REPUTIL
DBMS_REPUTIL2
DBMS_RESOURCE_MANAGER
DBMS_RESOURCE_MANAGER_PRIVS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RESUMABLE
DBMS_RLS
DBMS_RMGR_GROUP_EXPORT
DBMS_RMGR_PACT_EXPORT
DBMS_RMGR_PLAN_EXPORT
DBMS_RMIN
DBMS_ROWID
DBMS_RULE
DBMS_RULEADM_INTERNAL
DBMS_RULE_ADM
DBMS_RULE_COMPATIBLE_90
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_RULE_EXIMP
DBMS_RULE_EXP_EC_INTERNAL
DBMS_RULE_EXP_EV_CTXS
DBMS_RULE_EXP_RL_INTERNAL
DBMS_RULE_EXP_RS_INTERNAL
DBMS_RULE_EXP_RULES
DBMS_RULE_EXP_RULE_SETS
DBMS_RULE_EXP_UTL
DBMS_RULE_EXP_UTLI
DBMS_RULE_IMP_OBJ
DBMS_SCHEDULER
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SCHED_CHAIN_EXPORT
DBMS_SCHED_CLASS_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS
DBMS_SCHED_JOB_EXPORT
DBMS_SCHED_MAIN_EXPORT
DBMS_SCHED_PROGRAM_EXPORT
DBMS_SCHED_SCHEDULE_EXPORT
DBMS_SCHED_WINDOW_EXPORT
DBMS_SCHED_WINGRP_EXPORT
DBMS_SCHEMA_COPY
DBMS_SERVER_ALERT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SERVER_ALERT_EXPORT
DBMS_SERVER_ALERT_PRVT
DBMS_SERVER_TRACE
DBMS_SERVICE
DBMS_SESSION
DBMS_SNAPSHOT
DBMS_SNAPSHOT_UTL
DBMS_SNAP_INTERNAL
DBMS_SNAP_REPAPI
DBMS_SPACE
DBMS_SPACE_ADMIN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SQL
DBMS_SQLHASH
DBMS_SQLPLUS_SCRIPT
DBMS_SQLTUNE
DBMS_SQLTUNE_INTERNAL
DBMS_STANDARD
DBMS_STATS
DBMS_STATS_INTERNAL
DBMS_STAT_FUNCS
DBMS_STAT_FUNCS_AUX
DBMS_STORAGE_MAP
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADM_UTL_INVOK
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_DATAPUMP
DBMS_STREAMS_DATAPUMP_UTIL
DBMS_STREAMS_DECL
DBMS_STREAMS_LCR_INT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_MT
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
DBMS_STREAMS_TBS_INT
DBMS_STREAMS_TBS_INT_INVOK
DBMS_SUMADV
DBMS_SUMADVISOR
DBMS_SUMMARY
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_SUMREF_UTIL
DBMS_SUMVDM
DBMS_SUM_RWEQ_EXPORT
DBMS_SUM_RWEQ_EXPORT_INTERNAL
DBMS_SWRF_INTERNAL
DBMS_SWRF_REPORT_INTERNAL
DBMS_SYSTEM
DBMS_SYS_ERROR
DBMS_SYS_SQL
DBMS_TDB
DBMS_TDE_TOOLKIT
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_TDE_TOOLKIT_FFI
DBMS_TRACE
DBMS_TRANSACTION
DBMS_TRANSACTION_INTERNAL_SYS
DBMS_TRANSFORM
DBMS_TRANSFORM_EXIMP
DBMS_TRANSFORM_EXIMP_INTERNAL
DBMS_TRANSFORM_INTERNAL
DBMS_TSM
DBMS_TSM_PRVT
DBMS_TTS
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_TYPES
DBMS_TYPE_UTILITY
DBMS_UNDO_ADV
DBMS_UPGRADE_INTERNAL
DBMS_UTILITY
DBMS_WARNING
DBMS_WARNING_INTERNAL
DBMS_WORKLOAD_REPOSITORY
DBMS_XMLGEN
DBMS_XMLSTORE
DBMS_XPLAN
OBJECT_NAME
--------------------------------------------------------------------------------
DBMS_XRWMV
DBMS_ZHELP
DBMS_ZHELP_IR
DIANA
DIUTIL
HTF
HTMLDB_SYSTEM
HTP
KUPC$QUEUE
KUPC$QUEUE_INT
KUPC$QUE_INT
OBJECT_NAME
--------------------------------------------------------------------------------
KUPCC
KUPD$DATA
KUPD$DATA_INT
KUPF$FILE
KUPF$FILE_INT
KUPM$MCP
KUPP$PROC
KUPV$FT
KUPV$FT_INT
KUPW$WORKER
LCR$_XML_SCHEMA
OBJECT_NAME
--------------------------------------------------------------------------------
LOGMNR_DICT_CACHE
ODCICONST
OUTLN_EDIT_PKG
OUTLN_PKG
OWA
OWA_CACHE
OWA_COOKIE
OWA_CUSTOM
OWA_CX
OWA_IMAGE
OWA_MATCH
OBJECT_NAME
--------------------------------------------------------------------------------
OWA_OPT_LOCK
OWA_PATTERN
OWA_SEC
OWA_TEXT
OWA_UTIL
PBREAK
PBRPH
PBSDE
PBUTL
PIDL
PLITBLM
OBJECT_NAME
--------------------------------------------------------------------------------
PRVT_ACCESS_ADVISOR
PRVT_ADVISOR
PRVT_DIMENSION_SYS_UTIL
PRVT_HDM
PRVT_SYS_TUNE_MVIEW
PRVT_TUNE_MVIEW
PRVT_UADV
PRVT_WORKLOAD
PRVT_WORKLOAD_NOPRIV
STANDARD
SYS_STUB_FOR_PURITY_ANALYSIS
OBJECT_NAME
--------------------------------------------------------------------------------
URIFACTORY
UTL_COLL
UTL_COMPRESS
UTL_ENCODE
UTL_FILE
UTL_GDK
UTL_HTTP
UTL_I18N
UTL_INADDR
UTL_LMS
UTL_MATCH
OBJECT_NAME
--------------------------------------------------------------------------------
UTL_RAW
UTL_RECOMP
UTL_REF
UTL_SMTP
UTL_SYS_COMPRESS
UTL_TCP
UTL_URL
UTL_XML
WPG_DOCLOAD
WPIUTL
WWV_FLOW_VAL
OBJECT_NAME
--------------------------------------------------------------------------------
XML_SCHEMA_NAME_PRESENT
441 rows selected.
SQL>
SQL>