Question;

>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
>

Answer 1:

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.

Answer 2:

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