Moving Indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Moving Indexes

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131
    Hey people;

    I have a dilema, I need to move about 2000 indexes from one tablespace to another. I can do them individually but there has to be an easier way than one at a time. Please help, Thank You

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Hi Mr Hankey,

    Get EZSQL. [url]http://www.ezsql.net.[/url] It can do this for you with a few clicks. (Select all of the indexes, then right-click and choose 'Create SQL to Rebuild', then fill in the options and click OK.) Even if you don't want to buy it, the trial will last 30 days and you can do it during that period.

    See ya this Christmas! :-)

    -John

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    Could u tell me which version of Oracle r u using. I think u can use the rebuild index command. All u need to do is put that in a script and run.

    Cheers,
    Vinit

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131

    Thanks

    You guys rock!!
    Thanks for the timely response. I actually posted this for a fellow DBA so I'm not sure which version he is using, or which OS.

    Jdorlon, you will get xtra poo this X-Mas

  5. #5
    Join Date
    Jan 2001
    Posts
    3,131
    Ok, here is the deal. He is using Oracle 8.16 on a Solaris 8 platform. Oracle reccomends running a script, any suggestions?

    Thanks Again, MH

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it's easy with sql*plus

    spool rebuild_index.sql
    select 'alter index '||index_name||' rebuild tablespace_idx;'
    from user_indexes
    /
    spool off

    then run rebuild_index.sql

    of course this prob seems harder than a gui tool but you learn how to do it in UNIX for example

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