Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
Description
SQL Optimizer For Oracle offers a correct solution, it's asking to create an INDEX that will help, but, the "Create Index Interface" does not offer the posiblity to creat a "LOCAL Index".
All INDEXES are by default set as GLOBAL, and sometimes the INDEX MUST BE LOCAL.
Can SQL Opt. include the option to create a LOCAL Index?
Resolution
WORKAROUND:
The INDEX must be created manually.
STATUS:
Being evaluated for inclusion in a future release of "SQL Optimizer For Oracle".
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Recommended Content
No results for undefined
Product(s):
SQL Optimizer for Oracle
9.2.3, 9.2.2
Topic(s):
Troubleshooting
Article History:
Created on: 11/13/2017 Last Update on: 5/7/2023
Thank you for your feedback for Topic Request
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.