Re: renaming the system tablespace datafile

In <3hterl$2ut_at_larch.cc.swarthmore.edu>, stauffer_at_cc.swarthmore.edu (R Glenn Stauffer) writes:
>I have an ORACLE 7.0.x database running and am attempting to rename the
>system tablespace datafile. When I do, I get this error message:
>
> ORA-01525: error in renaming data files
> ORA-01121: cannot rename database file 1 - file is in use or recovery
> ORA-01110: data file 1: '/u2/ORACLE/tele/dbs/systtele.dbf'
>
>I have tried this operation with the database mounted, but not open. This
>fails because the database isn't open. When I mount and open the database in
>exclusive mode, the operation fails with the above message.
>
>I altered all users so that none have system as the default or temporary
>tablespace (except users SYS and SYSTEM which have system as the default).
>
>I'm missing something!
>
>Glenn Stauffer
>DBA
>Swarthmore College

Try:

 sql>alter tablespace System offline;
 sql>alter tablespace System

       rename datafile 'drive:\path\OldDataFile.dbf' to 'drive:\path\'NewDataFile.dbf'  

after you have done the alter TS command you will have to rename/copy the file using your standard operating system commands to match the drive,path and filename used in the above statement. Finally, you will have to alter your tablespace to bring it back on-line.

M.Landa   Received on Thu Feb 16 1995 - 03:04:48 CET