Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Advice needed on moving datafiles

Re: Advice needed on moving datafiles

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Tue, 3 Aug 1999 10:39:11 +0100
Message-ID: <7o6dc5$5r8$1@taliesin.netcom.net.uk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US