Re: oracle 9i problems.. renaming datafiles

In article <aeqcdv$1vh$1_at_news6.svr.pol.co.uk> "mikeDesouza" <mike_at_archoak.fsworld.co.uk> writes:
>Hi
>
>I am trying to rename a datafile in oracle 9 release 1. I perform the
>following steps but somehow it fails and i have to perform media recovery .
>when I try and rename the datafile its say that some process is using in ,
>so when i try and bring it online it says it needs media recovery
>
> any help would be appreciated
>Mike
>
>SYS_at_PRACTICE> alter database datafile 4 offline;
>
>Database altered.
>
>SYS_at_PRACTICE> alter database datafile 4 online;
>alter database datafile 4 online
>*
>ERROR at line 1:
>ORA-01113: file 4 needs media recovery
>ORA-01110: data file 4: 'C:\ORACLE\ORADATA\PRACTICE\INDX01.DBF'

alter tablespace FOO offline;

do an OS-level move to the new location ("mv oldPath newPath")

alter tablsespace FOO rename datafile 'oldPath' to 'newPath'; alter tablespace FOO online;

HTH, Jim G. Received on Wed Jun 19 2002 - 12:22:05 CDT