Re: Procedure for Moving Datafile of SYSTEM Tablespace in 8i and 9i

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 02 Nov 2004 18:14:16 +0100
Message-ID: <cm8f99$3ru$1@news.BelWue.DE>

SAP BASIS Consultant wrote:
> Hello,
>
> I have used the procedure mentioned below a couple of times to
> move datafiles. Can I use the same procedure for moving
> the datafile associated with the SYSTEM tablespace, or are
> there other things I need to take into account for SYSTEM?
>
> Make backup.
>
> Bring down the DB.
>
> Copy the file using OS tools
>
> Startup mount <DB>;
>
> Alter database rename file '<old_location>' to '<new_location>';
>
> Alter database open;
>
> Backup the db and remove old file.

If you think about it, you'll realize that this actually is more or less the only way to go:

The database may not be open for moving datafiles of the system tablespace. For moving the datafile must be offline, but you can't take a datafile offline that's part of the system tablespace
You need the controlfile (after all, your modifying their content), hence you must have the database mounted.

Cheers,
Holger Received on Tue Nov 02 2004 - 11:14:16 CST