This discussion is archived
3 Replies Latest reply: Mar 16, 2013 10:48 PM by Girisha M - Oracle RSS

Error in UTL_SPADV.COLLECT_STATS

818442 Newbie
Currently Being Moderated
I have two installations of Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
And Real Application Testing options.

Bi-directional replication is configured at the table-level between the two databases.

I have tried running UTL_SPADV.COLLECT_STATS(interval => 30, num_runs => 2) in both databases.
In one it runs fine. In the other, I get:

ERROR at line 1:
ORA-01427: single-row subquery returns more than one row
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL", line 1986
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL_INVOK", line 1766
ORA-06512: at "SYS.DBMS_STREAMS_ADVISOR_ADM", line 79
ORA-06512: at "STRMADMIN.UTL_SPADV", line 3281
ORA-06512: at line 1

Any ideas what is causing this error?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points