How to move system, temporary or rollback datafiles on an eHealth server
You cannot use the nhManageDbSpace utility to move system, temporary or rollback datafiles because moving these datafiles require shutting down the database, then bringing the database up in a mount state to allow the control file to be updated while the database is not in use. Below is an example procedure used to move d:/ca/oradata/EHEALTH/SYSTEM01.dbf from d drive to e drive.
Stop the database, then start in a mount state
Exit the sql session
Move the file from its current location to a new location.
mv d:/ca/oradata/EHEALTH/SYSTEM01.dbf e:/ca/oradata/EHEALTH
Use Windows Explorer
Sign into sql session, as in step 1.
Change the database location of the datafile
alter database rename file 'd:/ca/oradata/EHEALTH/SYSTEM01.dbf' to 'e:/ca/oradata/EHEALTH/SYSTEM01.dbf';
alter database open;
Now you can start the server that will use the system01.dbf file in the new location.