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

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 2 Nov 2004 17:43:20 -0800
Message-ID: <42fc55dc.0411021743.75d424f8@posting.google.com>

basis_consultant_at_hotmail.com (SAP BASIS Consultant) wrote in message news:<dd2036f3.0411020744.4d1dbe32_at_posting.google.com>...
> 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.

That's pretty much it. That'll work.
And as an add-on: Actually if you're moving non-SYSTEM datafiles, you don't even have to bring down the whole DB to accomplish that. You just need to offline the relevant tablespace.

Cheers. Received on Tue Nov 02 2004 - 19:43:20 CST