Move or rename System datafiles
                                                 Last update (2011-06-06 10:19:30)
                                                                                                                   Date added (2008-02-11 14:26:00)

Summary
First of all you have to restart the database. Basically is the same with renaming datafiles with some small changes.

How to
For example, lets say that the name of the tablespace is SYSTEM and the datafile is '/filesystem01/system01.dbf' and you want to move it to '/filesystem02/system01.dbf'

1. First shutdown the database

sqlplus "/ as sysdba
shutdown immediate

2. Move the system datafile to the new filesystem with the os command.

$>mv /filesystem01/system01.dbf /filesystem02/system01.dbf

3. Startup and mount the database.

sqlplus>startup mount

4. Do the renaming

ALTER DATABASE RENAME FILE '/filesystem01/tbs01.dbf' TO '/filesystem02/tbs01.dbf';

5. Open the database.

alter database open;

Other links
Create new control file
Create new TEMPORARY tablespace
Create new UNDO tablespace
Move or rename datafiles