Advice needed on moving datafiles

We have a tablespace for all our indexes, which has two datafiles, df1 and df2. We have now aquired a new disk and I need to move this tablespace to the new disk (and to larger datafiles) to free up some space on the old disk.

There are approximately 120 indexes and some of them currently have extents on both file 1 and 2. There are also some primary key indexes.

If anybody has any advice or tips on the best way to go about doing this it would be greatly appreciated. The method I intend to use is :

1. Drop indexes that are on datafile df1.
2. drop datafile df1 from tablespace.
3. Add larger datafile newdf1 to tablespace.
4. recreate indexes that were dropped.
5. Repeat with datafile df2.

Will I have a problem with PK indexes?

Thanks in advance,

Dipen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 03:30:03 CDT