Re: MERGE table index fails to contain all records
Posted by:
ahigerd
Date: October 04, 2006 12:48PM
Okay, so I discovered the problem when I went to research it some more; it seems that the "indexes have to have the same order" thing is more strict than I expected. I thought that it meant that unique indexes had a different internal order than non-unique indexes. It actually means that the indexes have to be added to the table in the same order.
In my original case, I dropped the indexes off of all of my tables and recreated them and everything started behaving.
Subject
Views
Written By
Posted
10167
October 04, 2006 12:29PM
5753
October 04, 2006 12:38PM
Re: MERGE table index fails to contain all records
5624
October 04, 2006 12:48PM
5488
October 11, 2006 10:48AM
5532
November 20, 2006 11:56AM
5482
February 17, 2007 11:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.