Re: Moving system datafiles

From: InDfw <in_dfw_at_hotmail.com>
Date: 1998/01/04
Message-ID: <68mspa$srk@bgtnsc03.worldnet.att.net>#1/1

Shutdown the database
Cp the files to the new directory
Mount the database
Perform alter database rename datafile xxx to yyy

Roland Hall <rhall_at_ihatespam.com> wrote in article <68jel1$ksu$1_at_bali.seg.wj.com>...
> We are running oracle 7.14 on Solaris 2.4 with raw file systems. I need
to
> move the instance to a different set of disks. I have moved all of the
> datafiles except the system datafiles by taking the tablespace offline,
dd the
> datafiles to their new location, renaming them and bringing the
tablespace
> online. This procedure does not work for the system datefiles. Does
anyone
> have any suggestions on how to proceed?
>
> Thank You
>
> Roland Hall
> Systems Analyst
> Watkins-Johnson
>
> rhall_at_wj.com
>
Received on Sun Jan 04 1998 - 00:00:00 CST