parameter to disable/invisible  indexes

Posted on 2012-09-06
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 76

    Accepted Solution

    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

    Do this:

    alter index <index_name> invisible;

    To make it visible:

    ALTER SESSION | ALTER SYSTEM SET optimizer_use_invisible_indexes = TRUE

    For more info:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to recover a database from a user managed backup

    794 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now