Alterar Datafile de Local fisico

startup restrict mount

ALTER DATABASE DATAFILE ‘D:ORACLEORADATAGINFUNDOTBS01.DBF’ to ‘C:ora92oradataGINFUNDOTBS01.DBF’;

ALTER DATABASE rename TEMPFILE ‘d:oracleoradataGINFTEMP01.dbf’ to ‘C:ora92oradataGINFTEMP01.dbf’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFCWMLITE01.DBF’ to ‘C:ora92oradataGINFCWMLITE01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFDRSYS01.DBF’ to ‘C:ora92oradataGINFDRSYS01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFEXAMPLE01.DBF’ to ‘C:ora92oradataGINFEXAMPLE01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFINDX01.DBF’ to ‘C:ora92oradataGINFINDX01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFginftest.ora’ to ‘C:ora92oradataGINFginftest.ora’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFODM01.DBF’ to ‘C:ora92oradataGINFODM01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFSYSTEM01.DBF’ to ‘C:ora92oradataGINFSYSTEM01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFTOOLS01.DBF’ to ‘C:ora92oradataGINFTOOLS01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFUSERS01.DBF’ to ‘C:ora92oradataGINFUSERS01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFXDB01.DBF’ to ‘C:ora92oradataGINFXDB01.DBF’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO01.LOG’ to ‘C:ora92oradataGINFREDO01.LOG’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO02.LOG’ to ‘C:ora92oradataGINFREDO02.LOG’;

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO03.LOG’ to ‘C:ora92oradataGINFREDO03.LOG’;

alter database clear unarchived logfile ‘C:ora92oradataGINFREDO03.LOG’;