Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MOVE DATAFILE SCO UNIX possible ?
Erik,
You can change the location of the datafile by re-creating the controlfile. After connecting internal, type "alter database backup controlfile to trace". Exit and cd to the trace directory. Your latest trace file will be a script that you can run to re-create the controlfiles. Shutdown and backup the database, move the datafile to the new location, modify the trace file/script so that the entry regarding the datafile reflects the new path, then connect internal and start the modified trace file. This will recreate your controlfiles, modifying the path to the moved datafile. Backups before AND AFTER are important.
Steve
Erik Oosterling <Oosterling_at_compuserve.com> wrote in article
<32ec5949.1103399_at_news.xs4all.nl>...
> Hello,
>
> i made a small mistake. I made a datafile on the wrong disk, is it
> possible to move this to the right place.
>
> Please HELP !!!!!!!!!!!!!!!!!
>
>
> BTW it is a part of the system tablespace.
>
> Greatings,
>
> Erik Oosterling
>
> 101756,3156 <-> Compuserve
> 101756.3156_at_compuserve.com <-> Internet
> ErikO_at_cmg.nl <-> Internet
>
Received on Tue Jan 28 1997 - 00:00:00 CST