EXECUTE UTL_RECOMP.RECOMP_PARALLEL(4); JOB_QUEUE_PROCESSESパラメータに指定されたスレッド数を使用し、スキーマJOEのオブジェクトを再コンパイルする場合: EXECUTE UTL_RECOMP.RECOMP_PARALLEL(NULL, 'JOE'); UTL_RECOMPサブプログラムの要約 表214-1 UTL_RECOMPパッケージのサブプログラム...
BEGIN SYS.UTL_RECOMP.RECOMP_SERIAL('SCOTT'); END; * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at "SYS.UTL_RECOMP", line 662 ORA-06512: at "SYS.UTL_RECOMP", line 715 ORA-06512: at line 1 ...
- utl_recomp_comp_idx1 - utl_recomp_sort_idx1 - utl_recomp_sort_idx2 and is called at the start of recomp_parallel which is what recomp_serial calls passing the number of threads as 1. So the very first thing it does it drop the indexes. The indexes are also referenced in fun...
Ora-955 Error Running Utl_Recomp.Recomp_Serial (Doc ID 1274504.1)Last updated on FEBRUARY 18, 2025 Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform....
【操作系统】：Centos7 【CPU】:Intel X86 【问题描述】*：达梦有没有类似ORACLE UTL_RECOMP.RECOMP...
UTL_RECOMP_INVALID_MV 無効だが循環依存チェーンがないマテリアライズド・ビュー・オブジェクトをUTL_RECOMP_ALL_OBJECTSから選択したビュー。 UTL_RECOMP_ALL_STUBS コンパイルされておらずスキップ・リストにないすべてのスタブ・オブジェクトを含むビュー。このビューをRECOMP_PARA...
API utl_recomp.recomp_serial for recompile the invalid object gives the below error: ORA-20000: Unable to gather statistics concurrently: Resource manager plan is not active or is not managing CPU usageORA-06512: at "SYS.UTL_RECOMP", line 888ORA-06512: at "SYS.TRIO_RECOMP_OBJECTS", ...
The UTL_RECOMP package recompiles invalid PL/SQL modules, invalid views, Java classes, indextypes and operators in a database, either sequentially or in parallel.
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later: dbms_utility.compile_schema - ORA-20000: Unable To Set Values For Index UTL_RECOMP_SORT_IDX1