Oracle-L: RE: ORA-1410 Silliness

From: Sherman, Edward <shermanej_at_eccic.com>
Date: Thu, 02 Jan 2003 07:34:09 -0800
Message-ID: <F001.0052577E.20030102073409@fatcity.com>

I found this in the Oracle Concepts manual. Since your table is partitioned I thought it might be worth a look.

Queries and Partition Maintenance Operations

BM_449158Queries whose execution starts before invocation of a partition maintenance operation, or before dictionary updates are done during a partition maintenance operation, correctly access via Consistent Read the data of the affected partitions as existing at query snapshot time. Such queries either successfully complete returning all relevant data as present at snapshot time, or fail to complete returning error ORA-8103 or ORA-1410. The application should reissue the query if one of these errors is returned.

BM_430607Queries that use a partitioned index, and that start with some of the index partitions marked as INDEX UNUSABLE, return an error when they actually access one of these partitions for the first time. This happens even if the partition has been made USABLE after query start.

Good luck

-----Original Message-----
Sent: Tuesday, December 31, 2002 12:49 PM To: Multiple recipients of list ORACLE-L

You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design. I wasn't given a chance to improve on it. It is basically a mainframe file that I have stored history of.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Sherman, Edward
INET: shermanej_at_eccic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 02 2003 - 09:34:09 CST