3 Replies Latest reply on Mar 17, 2013 5:48 AM by Girisha M -Oracle


      I have two installations of Oracle Database 11g Enterprise Edition Release - 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?