Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba objects
Содержание
Get all system packages
<source lang="sql">
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.</source>
Get the creation time and updated time for dba objects
<source lang="sql">
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></source>
List all sys owned package name
<source lang="sql">
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.</source>
Query dba_objects by owner
<source lang="sql">
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></source>
Query dba_objects for owner name and object type
<source lang="sql">
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></source>