Re: Advice needed on moving datafiles

In article <7o6dc5$5r8$1_at_taliesin.netcom.net.uk>,   "Alex Hudghton" <alex_at_alenda.freeserve.co.uk> wrote:
>
> 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
>
>

Thanks for that Alex. I didn't realise I could do that. You just saved me a whole load of work.

Dipen

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