parameter to disable/invisible  indexes

Posted on 2012-09-06
Medium Priority
Last Modified: 2012-09-24
Hello Experts,

i am looking for a parameter to disable/invisible all indexes in a database. could you please let me know if any parameter will the same task?
i am ok even if it is a hidden parameter
Question by:sk0227
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 38373683
ALL indexes in a database would also mean those on system tables.  That could be a bad thing.

Are you really after all indexes in a schema?

Anyway, I don't think such a thing exists.  You will need to write your own.

You will probably also need to make sure these indexes are not part of a constraint that enforces referential integrity.
LVL 23

Expert Comment

ID: 38374029
Do this:

alter index <index_name> invisible;

To make it visible:

ALTER SESSION | ALTER SYSTEM SET optimizer_use_invisible_indexes = TRUE

For more info: http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes004.htm#autoId3

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question