Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MERGE Statement - unable to get a stable set of rows in the source tables

426651Oct 19 2005 — edited Nov 7 2005

OWB Client: 10.1.0.2.0
OWB Repository: 10.1.0.1.0

I am trying to create a MERGE in OWB.
I get the following error:

ORA-12801: error signaled in parallel query server P004 ORA-30926: unable to get a stable set of rows in the source tables

I have read the other posts regarding this and can't seem to get a fix.

The target table has a unique index on the field that I am matching on.
The "incoming" data doesn't have a unique index, but I have checked and confirmed that it is unique on the appropriate key.

The "incoming" data is created by a join and filter in the mapping and I'd rather avoid having to load this data into a new table and add a unique index on this.

Any help would be great.
Thanks
Laura

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2005

Added on Oct 19 2005

#data-warehousing, #warehouse-builder

10 comments

903 views