Oracle技术分享，如何产生编译无效公共同义词的语句

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;

思庄秉承培训+认证一站式的贴心服务，一线工程师讲师线上+线下精心全方位授课，更高效的的学习IT技术。期待对IT行业感兴趣的您加入QQ：2665308420