Re: Moving SYSTEM datafile

From: TurkBear <john.greco_at_dot.state.mn.us>
Date: Tue, 17 Dec 2002 16:09:05 -0600
Message-ID: <7q7vvu4h4hu15hmug7tcm52botgspfucks@4ax.com>

AFAIK, no..You cannot put the SYSTEM tablespace offline that way.. But, you may be able to do it while 'offline' ; if the database is down, you could probably copy the data files that make up the system tablespace to a new location, edit the control files ( carefully) to indicate the new location and start it up..

just an thought, and it may not work so test first..

Rick Denoire <100.17706_at_germanynet.de> wrote:

>I can "move" an Oracle datafile by using the statement
>alter database move datafile "Path-to-datafile" to "new-path"
>if I put the corresponding Tablespace offline and actually copy the
>file before setting it online again.
>
>Can I do that with the SYSTEM datafile?
>
>Thanks
>Rick Denoire
Received on Tue Dec 17 2002 - 16:09:05 CST