Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Moving Datafile Associated With SYSTEm Tablespace
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