Alterar Datafile de Local fisico

startup restrict mount

ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\GINF\UNDOTBS01.DBF' to 'C:\ora92\oradata\GINF\UNDOTBS01.DBF';

ALTER DATABASE rename TEMPFILE 'd:\oracle\oradata\GINF\TEMP01.dbf' to 'C:\ora92\oradata\GINF\TEMP01.dbf';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\CWMLITE01.DBF' to 'C:\ora92\oradata\GINF\CWMLITE01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\DRSYS01.DBF' to 'C:\ora92\oradata\GINF\DRSYS01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\EXAMPLE01.DBF' to 'C:\ora92\oradata\GINF\EXAMPLE01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\INDX01.DBF' to 'C:\ora92\oradata\GINF\INDX01.DBF';



ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\ginftest.ora' to 'C:\ora92\oradata\GINF\ginftest.ora';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\ODM01.DBF' to 'C:\ora92\oradata\GINF\ODM01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\SYSTEM01.DBF' to 'C:\ora92\oradata\GINF\SYSTEM01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\TOOLS01.DBF' to 'C:\ora92\oradata\GINF\TOOLS01.DBF';



ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\USERS01.DBF' to 'C:\ora92\oradata\GINF\USERS01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\XDB01.DBF' to 'C:\ora92\oradata\GINF\XDB01.DBF';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\REDO01.LOG' to 'C:\ora92\oradata\GINF\REDO01.LOG';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\REDO02.LOG' to 'C:\ora92\oradata\GINF\REDO02.LOG';

ALTER DATABASE rename FILE 'd:\oracle\oradata\GINF\REDO03.LOG' to 'C:\ora92\oradata\GINF\REDO03.LOG';



alter database clear unarchived logfile 'C:\ora92\oradata\GINF\REDO03.LOG';