select 'alter ' || owner || ' ' || object_type || ' ' || object_name || ' compile;' comp_stat from dba_objects where status<>'VALID' and object_type='SYNONYM' order by 1;
COMP_STAT
--------------------------------------------------------------------------------
alter PUBLIC SYNONYM AUTO_DAY_STAT compile;
alter PUBLIC SYNONYM AUTO_MONTH_STAT compile;
alter PUBLIC SYNONYM CALC_SCHEME compile;
alter PUBLIC SYNONYM CHARGE_BY_SHEET compile;
alter PUBLIC SYNONYM CHARGE_BY_SHEET_001 compile;
alter PUBLIC SYNONYM DAY_ADT2 compile;
alter PUBLIC SYNONYM EXECUTE_ALL_NO_PROS compile;
alter PUBLIC SYNONYM GETPATVISIT_ADM_DT compile;
alter PUBLIC SYNONYM HWS_DATA_UP compile;
alter PUBLIC SYNONYM LAB_CHARGE compile;
alter PUBLIC SYNONYM LAB_ITEM_CHARGE compile;
alter PUBLIC SYNONYM MANAGER_PAY_WAY_PROC compile;
alter PUBLIC SYNONYM MONTH_ACCOUNT_DEPT compile;
alter PUBLIC SYNONYM MONTH_ACCOUNT_ITEM compile;
alter PUBLIC SYNONYM MONTH_ADM compile;
alter PUBLIC SYNONYM MONTH_EFFCIENCY compile;
alter PUBLIC SYNONYM MONTH_MANAGE compile;
alter PUBLIC SYNONYM MONTH_OPERATION compile;
alter PUBLIC SYNONYM MONTH_OTHER compile;
alter PUBLIC SYNONYM MONTH_STAT compile;
alter PUBLIC SYNONYM MONTH_THERAPY compile;
alter PUBLIC SYNONYM MON_OPERATION compile;
alter PUBLIC SYNONYM MON_OPER_EFFCI compile;
alter PUBLIC SYNONYM MON_O_EFFCI compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_CHN_DISEA compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_CHN_SYNDR compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_DRUG_NATIONAL compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_OPERATION compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_OPERTDIAG compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_PAYFOR_DISEASE compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_SPECIAL_DIAG compile;
alter PUBLIC SYNONYM NEWINSUR_DIR_TUMOR_FORM compile;
alter PUBLIC SYNONYM PROCESS_ACT_INDEX_EXAM_NO compile;
alter PUBLIC SYNONYM PROCESS_ACT_INDEX_TEMP_ORDER compile;