查询oracle表时可以跳过特定分区吗？
这背后的原因是我有一个已知的坏分区。我正在尝试继续使用数据库，同时 DBA 修复损坏的分区。当然还有更多信息可用，但我不知道是否可能，所以我想我应该先从这个问题开始。
我得到的错误是ORA-29954：域索引分区被标记为LOADING/FAILED/UNUSABLE。我知道正确的做法是修复分区，但作为一名程序员，我没有权限或技能来这样做。我目前所能做的就是尝试跳过分区。
The reason behind this is that I have a known bad partition. I am trying to continue working with the database while the broken 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这是关于分区修剪的好信息。它可以帮助您更改查询以避免“坏”分区。
http://www.orafaq.com/tuningguide/partition%20prune.html
除此之外，您可能必须显式引用所有分区来扫描并手动忽略坏分区。
希望这有帮助，
奥利
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