Re: Moving Datafile Associated With SYSTEm Tablespace

Invoke Server Manager.
Shutdown the database. (shutdown immediate) Copy the files you want to rename(relocate) (E.g. "cp opt1/oradata/system1.dbf /opt2/oradata/system1.dbf" )
Startup the database without opening it. (startup mount) Issue the following command:
  ALTER DATABASE RENAME FILE 'opt1/oradata/system1.dbf' TO 'opt2/oradata/system1.dbf';
then
 ALTER DATABASE OPEN; This is the only option. You cannot do ALTER TABLESPACE... for system datafile

Yuri Korostyshevskiy

Tina Tran wrote:

> Hmm, I am surprised to hear that rename datafile does not work with system
> tablespace. Are you sure? Have you tried another alternative: rebuild the
> control file?
>
> Garry Smith <garry.smith_at_usa.net> wrote in article
> <OGV#3kR$8GA.311_at_upnetnews02.moswest.msn.net>...
> > Hello,
> >
> > I'm running Oracle7.3 on an HP-UX 10 platform. I want to change the
> > location of the datafile associated with the SYSTEM tablespace, does
 anyone
> > have any ideas?
> >
> > Please note that the ALTER TABLESPACE...RENAME DATAFILE, comand cannot be
> > used for the SYSTEM tablespace. I was thinking maybe an export and
> > re-build - what says you all?
> >
> > Please reply here wih your thoughts, or by emailing me at
> > garry.smith_at_usa.net.
> >
> > Thanks in anticipation,
> >
> > Garry
> >
> >
> >
Received on Mon Dec 01 1997 - 00:00:00 CST