Oracle PL/SQL Tutorial/System Tables Data Dictionary/dba objects

Материал из SQL эксперт
Перейти к: навигация, поиск

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>