Saturday, 20 May 2017

how to alter invalid objects by using altercommand in Oracle ?

alter MATERIALIZED VIEW APPS.OE_ITEMS_MV compile;
alter procedure XXFIN.XXFIN_PROC COMPILE;
ALTER FUNCTION XXFIN_XXFIN_FUN COMPILE;
alter view APPS.XXFIN_VIEW COMPILE;
ALTER SYNONYM XXEC.OKL_STRM_TYPE_V COMPILE;
alter type APPS.CSI_ITEM_INSTANCE_OBJ compile;
alter package APPS.ARW_SEARCH_CUSTOMERS compile body;
alter package APPS.CSI_WEB_SERVICE_PKG compile body;
alter trigger APPS.XXFIN_TRX_TRIGGER COMPILE;

No comments:

Post a Comment

Query to find request set and its responsibility

  SELECT FA.application_name,        fr.responsibility_name program_attached_to,        frg.request_group_name,        fcp.request_set_name,...