Oracle Error 30926
Contents |
friend ORA-30926: unable to get a stable set of rows in the source tables [message #429147] Mon, 02 http://www.orafaq.com/forum/t/151805/ November 2009 05:53 virmahi Messages: 266Registered: April 2008 Location: India Senior Member Hi, I am trying to merge some data into the target table named 'SMP_VENDOR_ITEM1' only for columns having FLAG = 'U' in table 'PARKING_SMP_VENDOR_ITEM'. Below is the structure of the two tables. CREATE TABLE PARKING_SMP_VENDOR_ITEM ( VENDOR_CODE VARCHAR2(30 BYTE) NOT NULL, ITEM_CODE VARCHAR2(32 BYTE), oracle error VENDOR_ITEM_STATUS NUMBER DEFAULT 0, FLAG CHAR(1 BYTE) DEFAULT 'U', UPDATE_STATUS CHAR(1 BYTE) DEFAULT 'N' ) INSERT INTO PARKING_SMP_VENDOR_ITEM ( VENDOR_CODE, ITEM_CODE, VENDOR_ITEM_STATUS, FLAG, UPDATE_STATUS ) VALUES ( '900', '10600103', 1, 'U', 'Y'); COMMIT; CREATE TABLE SMP_VENDOR_ITEM1 ( VENDOR_ITEM_ID NUMBER, VENDOR_ID VARCHAR2(30 BYTE), ITEMCODE VARCHAR2(32 BYTE), VENDOR_ITEM_STATUS NUMBER ) INSERT INTO SMP_VENDOR_ITEM1 ( VENDOR_ITEM_ID, VENDOR_ID, ITEMCODE, VENDOR_ITEM_STATUS ) oracle error 30926 VALUES ( 74704, '900', '10600103', 0); COMMIT; When I run the below Merge statement, I get error:- MERGE INTO smp_vendor_item1 USING parking_smp_vendor_item ON (smp_vendor_item1.vendor_id ='900' AND smp_vendor_item1.itemcode = '10600103') WHEN MATCHED THEN UPDATE SET smp_vendor_item1.VENDOR_ITEM_STATUS = 1 WHEN NOT MATCHED THEN INSERT (vendor_item_id, vendor_id, itemcode,vendor_item_status) values(125452,'900','10600103', 1 ); ORA-30926: unable to get a stable set of rows in the source tables Not sure what is going wrong..... If I run the same commands in a seperate schema for test...it runs fine but not in the schema where I am working Any clues? Regards, Mahi Report message to a moderator Re: ORA-30926: unable to get a stable set of rows in the source tables [message #429154 is a reply to message #429147] Mon, 02 November 2009 06:06 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator ORA-30926: unable to get a stable set of rows in the source tables *Cause: A stable set of rows could not be got because of lar