Oracle: Change source datafiles

sql> SHUTDOWN IMMEDIATE

From the operating system datafile move files to the new source

example:

[root @ oracledba name_instancia ] # mv -vi * dbf / u02/oradata/spartacus /

login as sqlplus / as sysdba

startup mount

SQL > ALTER DATABASE RENAME FILE ' / u01/app/oracle/oradata/name_instancia/system01.dbf ' TO ' / u02/oradata/name_instancia/system01.dbf ';

SQL > ALTER DATABASE RENAME FILE ' / u01/app/oracle/oradata/name_instancia/sysaux01.dbf ' TO ' / u02/oradata/name_instancia/sysaux01.dbf ';

SQL > ALTER DATABASE RENAME FILE ' / u01/app/oracle/oradata/name_instancia/users01.dbf ' TO ' / u02/oradata/name_instancia/users01.dbf ';

SQL > ALTER DATABASE RENAME FILE ' / u01/app/oracle/oradata/name_instancia/undotbs01.dbf ' TO ' / u02/oradata/name_instancia/undotbs01.dbf ';

SQL > ALTER DATABASE RENAME FILE ' / u01/app/oracle/oradata/name_instancia/example01.dbf ' TO ' / u02/oradata/name_instancia/example01.dbf ';

SQL > ALTER DATABASE OPEN ;

PD : As files are renamed tempfile not have to delete and re add :

SQL > ALTER DATABASE TEMPFILE '/ u01/app/oracle/oradata/name_instancia/temp01.dbf ' DROP ;

SQL > ALTER TABLESPACE TEMP ADD TEMPFILE '/ u01/app/oracle/oradata/name_instancia/temp01.dbf ' SIZE 500M ;


END