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