Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP RE: RELOCATION SYSTEM FILES
shutdown your database
copy whichever files you want to move
copy c:\blah\system01.dbf d:\blah2\system01.dbf
startup mount
alter database rename file 'c:\blah\system01.dbf' to
'd:\blah2\system01.dbf';
then
alter database open;
Then you should be done, this works for both log and data files. What I
do though is before shutdown I generate a sql script (in sqlplus) to
spool all of the changes for me and I run it. Some thing like this:
spool foo.sql
select 'alter database rename file '''||file_name||....
you get the point.
Enjoy,
Glen
mark.ragan_at_dial.pipex.com wrote:
>
> Could anyone please advise me how to move the "SYSTEM" tablespace &
> redo LOG files from one drive to another on Windows NT.
>
> I am unable to use tablespace manager because I cannot set SYSTEM to
> offline!
>
> Thanks
--
<html>
<font face="Tahoma"
size=1>|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-|<br>
Glen
Upreti<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>
<br>
Oracle
DBA<x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab>
<br>
Northern Arizona University<br>
Phone: (520)523-8393
<x-tab> </x-tab>Fax:(520)523-7407<br>
Glen.Upreti_at_nau.edu<br>
</font></html>
Received on Thu Jan 14 1999 - 17:14:19 CST