DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Index Script

  1. #1
    Join Date
    Jan 2001
    Posts
    61
    How I can get the script for all the Indexes in the Database.I need to create the same Indexes in another database with totally identical objects.I have Oracle7.3.4 Database.

    Thanks

    Ravi

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    you'll have to generate it from user_ind_columns ...
    and be careful since PK indexes are constraints ...

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    1. do a full export with rows=n (exp system/manager file=xyz.dmp full=y rows=n)
    2. import with indexfile=xyz.sql (imp system/manager file=xyz.dmp indexfile=xyz.sql)
    3. your indexes are now defined in xyz.sql
    Jeff Hunter

  4. #4
    Join Date
    Jan 2001
    Posts
    61
    Is there any tool available to do this.

  5. #5
    Join Date
    Nov 2000
    Posts
    344
    EZSQL, TOAD, SQL Navigator, Precise SQL...

    EZSQL is the best one though. And it costs less than
    all of the others. http://www.ezsql.net

    the exp/imp method is really very easy though.

    -John

  6. #6
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Originally posted by jdorlon
    EZSQL is the best one though. And it costs less than
    all of the others.
    Now *there's* an un-biased endorsement if ever I heard one

    - Chris

    PS - so, if I give you a plug in my book, can I get a 'free' copy?

  7. #7
    Join Date
    Nov 2000
    Posts
    344
    Hell yeah!

    send me an email - john@ezsql.net


  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by chrisrlong
    PS - so, if I give you a plug in my book, can I get a 'free' copy?
    So, if we plug your book, do we get a free copy? No wait, that won't work. Can we get a free copy of your book so we can plug it?
    Jeff Hunter

Posting Permissions

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


Click Here to Expand Forum to Full Width