How to Batch Compile Objects in a Database Cloud Schema Service
(Doc ID 1966708.1)
Last updated on AUGUST 09, 2017
Applies to:
Oracle Database Cloud Service - S5 - Version N/A and laterInformation in this document applies to any platform.
Goal
Recompile all pl/sql objects after changes are made to tables, packages, functions, triggers, etc on the Oracle Database Cloud Schema Service using DBMS_UTILITY an UTL_RECOMP.
However, these utilities give the following errors when used:
error : ORA-06550: line 3, column 1:
PLS-00201: identifier 'DBMS_UTILITY' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
begin
UTL_RECOMP.recomp_serial(schema => 'OUR_SCHEMA');
end;
ORA-06550: line 3, column 1:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
PLS-00201: identifier 'DBMS_UTILITY' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
begin
UTL_RECOMP.recomp_serial(schema => 'OUR_SCHEMA');
end;
ORA-06550: line 3, column 1:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_SERIAL' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |