Re: Question: Safest way to 'recreate' a tablespace

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Wed, 26 Oct 2005 22:06:50 +0200
Message-ID: <435fe1db$0$20221$ba620e4c@news.skynet.be>

"gazzag" <gareth_at_jamms.org> wrote in message news:1130356501.052393.326630_at_g44g2000cwa.googlegroups.com...
>I believe the Oracle documentation gives an example of this:
>
> 1. alter tablespace <tablespace_name> offline normal;
>
> 2. Copy the datafile in question to the desired location with the
> relevant O/S command.
>
> 3. alter tablespace <tablespace_name> rename datafile
> '<old_datafile_name>' to '<new_datafile_name>';
>
> 4. alter tablespace <tablespace_name> online;
>
> Clean up by deleting the unwanted datafile with the O/S.
>

This will only *move* the datafile, not remove it from the tablespace. I believe dropping datafiles from tablespaces is only supported in 10g Release 2.

Matthias Received on Wed Oct 26 2005 - 15:06:50 CDT