Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Unanswered: Index Definition Script Needed

    Hi,

    Does anyone has the script to get all the index definition from the Oracle Data Dictionary and to create a index creation script.

    I wanted to search entire thread but did not found search option.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    You can use SQL Developer (free) to do it (or if you prefer, use TOAD).


    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Apr 2007
    Posts
    2
    Thanks.

    I managed to do it by using following SQL on Oracle 9i

    select a.index_name,
    CURSOR (select dbms_metadata.get_ddl ('INDEX', p.index_name)
    from dba_indexes P
    where p.index_name = a.index_name)
    from dba_indexes a
    where a.owner = 'ARADMIN'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •