Re: Moving Datafile Associated With SYSTEm Tablespace

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/12/04
Message-ID: <3486B930.1C505699@gatwick.geco-prakla.slb.com>#1/1

Garry Smith wrote:

> I'm running Oracle7.3 on an HP-UX 10 platform. I want to change the
> location of the datafile associated with the SYSTEM tablespace, does anyone
> have any ideas?
>
> Please note that the ALTER TABLESPACE...RENAME DATAFILE, comand cannot be
> used for the SYSTEM tablespace. I was thinking maybe an export and
> re-build - what says you all?

This can be used (and I have) if the database is in mount mode;

shutdown immediate;

startup mount;

!cp old_file new_file

alter database rename file 'old_file' to 'new_file';

alter database open;

Hope this helps,

Ian Received on Thu Dec 04 1997 - 00:00:00 CST