Re: Advice needed on moving datafiles

dipenk_at_my-deja.com wrote in message <7o69a4$3de$1_at_nnrp1.deja.com>...
>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
>

Why not just move and rename the existing files ? Checkout Renaming and Relocating Datafiles in the System Administrator's Guide.

Alex Received on Tue Aug 03 1999 - 04:39:11 CDT