SQL-PLUS script for moving indexes to separate tables space

From: Jeff <idunno_at_ix.netcom.com>
Date: 1996/05/29
Message-ID: <31ACEA7C.FB4_at_ix.netcom.com>#1/1


Greetings:

Has anyone written an SQL-PLUS script to move an Oracle users indexes to a different tablespace?

In psuedo-code:

  1. Get all the indexes for a user.
  2. Drop the index.
  3. re-create the index in a separate tablespace.

Thanks for any help.

ed
schaefer
jeff
mirliss Received on Wed May 29 1996 - 00:00:00 CEST

Original text of this message