DBA Hub

📋Steps in this guide1/1

Compile invalid objects

-- To compile all objects in database

oracle configurationintermediate
by OracleDba
15 views
1

Compile invalid objects

-- To compile all objects in database -- Compile objects of a particular schema: -- Compiling a package; -- Compiling a procedure: -- Compiling a view: -- Compiling a function:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
@$ORACLE_HOME/rdbms/admin/utlrp.sql
EXEC DBMS_UTILITY.compile_schema(schema => 'APPS');
ALTER PACKAGE APPS.DAIL_REPORT COMPILE;
ALTER PACKAGE APPS.DAIL_REPORT COMPILE BODY;
ALTER PROCEDURE APPS.REPORT_PROC COMPILE;
ALTER VIEW APPS.USERSTATUS_VW COMPILE;
ALTER FUNCTION APPS.SYNC_FUN COMPILE;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!