oracle+视图设成无效,oracle 10g 升级到10.2.0.5.0后有10个aq$ 视图无效

1.升级完成 查询

select owner,object_name,subobject_name,object_type,status from dba_objects where status<>'VALID';

有10个无效view 视图，之前utlrp.sql   catalog.sql   catproc.sql 都运行过了

手动编译一个是可以编译的。AQ$视图应该是streams Advanced Queue

2.select 'alter view '||object_name|| ' compile;' from dba_objects where status<>'VALID';

alter view AQ$_AQ_SRVNTFN_TABLE_F compile;

alter view AQ$AQ_SRVNTFN_TABLE compile;

alter view AQ$_SCHEDULER$_JOBQTAB_F compile;

alter view AQ$SCHEDULER$_JOBQTAB compile;

alter view AQ$SCHEDULER$_JOBQTAB_R compile;

alter view AQ$_SCHEDULER$_EVENT_QTAB_F compile;

alter view AQ$SCHEDULER$_EVENT_QTAB_R compile;

alter view AQ$_AQ$_MEM_MC_F compile;

alter view AQ$_ALERT_QT_F compile;

3.执行ok