sql>desc system. repcat$_runtime_parms查看这个表的结构.然后做修改如下:
sql> alter table system. repcat$_runtime_parms add primary key (runtime_parm_id,parameter_name) rely disable;
修改完以后再做上面的查询以确认没有表需要再做修改:
sql> select owner, table_name, bad_column from dba_logstdby_not_unique
2> where table_name not in (select table_name from dba_logstdby_unsupported);
owner table_name b
------------------------------ ------------------------------ -
outln ol$hints n
outln ol$nodes n
system mview$_adv_basetable n
system mview$_adv_sqldepend n
system mview$_adv_filterinstance n
system def$_origin n