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
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:
- Get all the indexes for a user.
- Drop the index.
- 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