Re: Renaming SYSTEM tablespace file

No need to be as complicated as this. All you need to do is shutdown the database, copy the SYSTEM tablespace to the new location, STARTUP MOUNT, ALTER DATABASE RENAME FILE 'oldsystem.dbf' to 'newsystem.dbf', ALTER DATABASE OPEN.

Syntax is from memory so check the manuals first!

HTH. Pete

Jason Salter wrote:

> On Thu, 30 Sep 1999 15:51:25 +0200, "Maoz Mussel" <maoz_at_mindcti.com>
> wrote:
>
> >Hello,
> >
> >This question probably have a straight forward answer, but I can't find one:
> >How do I move a SYSTEM tablespace file to a new location? I can't take
> >it offline, so I can't safely move the file to the new location. I haven't
> >found reference to this issue on Oracle's documentation.
> >
> >Thanks,
> >Maoz
> >
>
> One option :-
>
> 1) You could do a ALTER DATABASE BACKUP CONTROL FILE TO TRACE;
>
> 2) Shut the database down tidely
>
> 3) Move the SYSTEM datafile to it's new location.
>
> 4) Edit the trace file to reflect the moved system ts datafile.
>
> 5) Startup nomount the database
>
> 6) Recreate the contolfiles using the trace file.
>
> 7) Open the database for business.
>
> 8) Tada!
>
> Regards,
> Jason.

Received on Thu Sep 30 1999 - 11:36:36 CDT