Re: Alter database rename datafile question

Yes, is that simple, except for one caveat:

ORACLE recommends taking the tablespace offline before the RENAME operation. However, you cannot take the SYSTEM tablespace offline. Therefore, for the SYSTEM tablespace you may want to use ALTER DATABASE.... command rather than the ALTER TABLESPACE..., as follwows:

alter database rename datafile '/disk1/system01.dbf' to '/disk2/system01.dbf';

I hope this helps.

Michael Serbanescu
Sr. ORACLE DBA, TRECOM Business Systems, Edison, NJ ms_at_cmprime.cis.att.com
(908)576-3894

• There is light at the end of the tunnel and it's.......the train !!!! *

  ---

  ---

  janet wrote:
  >
  > Hi,
  > I'd like to move an entire instance from one logical disk to
  > another. It's not a big one, only 5 tablespaces, and 4 of them
  > are SYSTEM, RBS, TEMP, and TOOLS.
  > Is the move as simple as:
  > alter tablespace TBSP_NAME rename datafile '/disk1/system01.dbf' to
  > '/disk2/system01.dbf'
  > ?????
  > (v7.0)
  > thanks
  > janet