Re: Moving SYSTEM datafile

From: Jimmy Collins <jimmy_at_jcollins.de>
Date: Tue, 17 Dec 2002 23:10:47 +0100
Message-ID: <3i7ota.3i1.ln@10.1.1.1>

"Rick Denoire" <100.17706_at_germanynet.de> schrieb im Newsbeitrag news:ee6vvu0lb6iqk7ciit7omtk4vsuq508tfd_at_4ax.com...
> 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.

no - you can´t.

- shutdown database
- move tablespace
- startup nomount
- alter database move datafile ...
- alter database mount
- alter database open

Jimmy

--
having trouble in windows - reboot
having trouble in linux - be root

Received on Tue Dec 17 2002 - 16:10:47 CST