Looks good. Does fol mean following?
Thanks,
Ken
-Original Message-
Sent: Wednesday, November 21, 2001 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject:Re: Fixing a DB
Sorry forgot the command in my earlier email
To recap, here are the steps
1. create the new
The only problem with this technique is that you won't reclaim the space in
the first tablespace that used to be used by the indexes (since the high
water marke will be set). If this isn't an issue (either lots of storage
space or the data is expected to grow enough to use this space) then I
Why not just create the tablespace and move the indexes? alter index rebuild
with new storage parameters.
-Original Message-
From: Ken Janusz [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 21, 2001 8:26 AM
To: Multiple recipients of list ORACLE-L
Subject: Fixing a DB
Ken,
I don't think you will need steps 2 thru 5. After step 1, just write sql
that will spool out alter index blah rebuild tablespace new_tablspace
run the resulting sql.
Will that work ?
HTH
Srini Chavali
Oracle DBA
Cummins Inc
Ken Janusz [EMAIL PROTECTED]@fatcity.com on 11/21/2001
Sorry forgot the command in my earlier email
To recap, here are the steps
1. create the new tablespace
2. For all indexes that need to be moved, run the fol command
alter index index_owner.index_name rebuild online tablespace
new_tablespace;
From: Ken Janusz [EMAIL PROTECTED]
Reply-To: