From: lorna_yan@yahoo.com (Lorna)
Newsgroups: comp.databases.oracle.server
Subject: Re: please help on error on partitioned tables
Date: 12 Dec 2001 16:54:36 -0800
Organization: http://groups.google.com/
Lines: 31
Message-ID: <1993753c.0112121654.730d6961@posting.google.com>
References: <1993753c.0112110158.4f1aa66f@posting.google.com>
NNTP-Posting-Host: 192.11.188.113
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008204876 8966 127.0.0.1 (13 Dec 2001 00:54:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 13 Dec 2001 00:54:36 GMT


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 */