Re: please help on error on partitioned tables

Thank aviion very much for your message. I asked them to check the USER_TABLES.mrow_movement for the table partitioned and it was 'DISABLED'. But after they update it to 'ENABLED' the error still remians.

Do you think it is possible there are some problem in the way partitioning or it might be possible that the ROWID is not dependable due to unrefreshed guess in logical rowids? The table is indexed on some of its columns. I'm a beginner on oracle and this seems a very difficult issue to me. Appreciate your help. Attached here the log where it errored out:

/* Command(sequence 128) start: 12/11/01 16:32:34 */
SELECT D.ROWID FROM INVOICE_DETAIL D, INVOICE I WHERE I.account_no = 2 AND I.index_bill_ref=D.index_bill_ref AND I.index_bill_ref_resets=D.index_bill_ref_resets
/* Command(sequence 128) end: 12/11/01 16:32:34. Elapsed time in
seconds: 0 */

/* Command(sequence 129) start: 12/11/01 16:32:34 */
COMMIT
/* Command(sequence 129) end: 12/11/01 16:32:34. Elapsed time in
seconds: 0 */

/* Command(sequence 130) start: 12/11/01 16:32:34 */
DELETE FROM INVOICE_DETAIL WHERE ROWID IN ('AAADdBAAGAAACPdAAA','AAADdBAAGAAACPdAAB','AAADdBAAGAAACPdAAC','AAADdBAAGAAACPdAAD','AAADdBAAGAAACPdAAE','AAADdBAAGAAACPdAAF','AAADdBAAGAAACPdAAG','AAADdBAAGAAACPdAAH','AAADdBAAGAAACPdAAI','AAADdBAAGAAACPdAAJ')
/* Command(sequence 131) start: 12/11/01 16:32:35 */
COMMIT
/* Command(sequence 131) end: 12/11/01 16:32:35. Elapsed time in
seconds: 0 */ Received on Wed Dec 12 2001 - 18:54:36 CST