Can I skip a specific partition when querying an oracle table?

The reason behind this is that I have a known bad partition. I am trying to continue working with the database while the broken开发者_JS百科 partition is fixed by the DBA. There is of course more information available, but I don't know if it is even possible, so I figured I'd start with the question first.

The error I get is ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE. I know that the right thing to do is to fix the partition, but being just a programmer, I don't have access or skills to do so. All I can do at the moment is attempt to skip over the partition.

This is a good piece of information on partition pruning. It may help you to alter your queries to avoid the "bad" partition.

http://www.orafaq.com/tuningguide/partition%20prune.html

Other than that, you might have to explicitly reference all partitions to scan and manually omit the bad partition.

Hope this helps, Ollie