{"id":188,"date":"2008-02-17T20:35:00","date_gmt":"2008-02-17T23:35:00","guid":{"rendered":"http:\/\/www.soudba.com.br\/?p=188"},"modified":"2008-02-17T20:35:00","modified_gmt":"2008-02-17T23:35:00","slug":"alterar-datafile-de-local-fisico","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=188","title":{"rendered":"Alterar Datafile de Local fisico"},"content":{"rendered":"

startup restrict mount<\/p>\n

ALTER DATABASE DATAFILE ‘D:ORACLEORADATAGINFUNDOTBS01.DBF’ to ‘C:ora92oradataGINFUNDOTBS01.DBF’;<\/p>\n

ALTER DATABASE rename TEMPFILE ‘d:oracleoradataGINFTEMP01.dbf’ to ‘C:ora92oradataGINFTEMP01.dbf’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFCWMLITE01.DBF’ to ‘C:ora92oradataGINFCWMLITE01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFDRSYS01.DBF’ to ‘C:ora92oradataGINFDRSYS01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFEXAMPLE01.DBF’ to ‘C:ora92oradataGINFEXAMPLE01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFINDX01.DBF’ to ‘C:ora92oradataGINFINDX01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFginftest.ora’ to ‘C:ora92oradataGINFginftest.ora’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFODM01.DBF’ to ‘C:ora92oradataGINFODM01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFSYSTEM01.DBF’ to ‘C:ora92oradataGINFSYSTEM01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFTOOLS01.DBF’ to ‘C:ora92oradataGINFTOOLS01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFUSERS01.DBF’ to ‘C:ora92oradataGINFUSERS01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFXDB01.DBF’ to ‘C:ora92oradataGINFXDB01.DBF’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO01.LOG’ to ‘C:ora92oradataGINFREDO01.LOG’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO02.LOG’ to ‘C:ora92oradataGINFREDO02.LOG’;<\/p>\n

ALTER DATABASE rename FILE ‘d:oracleoradataGINFREDO03.LOG’ to ‘C:ora92oradataGINFREDO03.LOG’;<\/p>\n

alter database clear unarchived logfile ‘C:ora92oradataGINFREDO03.LOG’;<\/p>\n","protected":false},"excerpt":{"rendered":"

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 … Continue lendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[151,245],"tags":[],"class_list":["post-188","post","type-post","status-publish","format-standard","hentry","category-local-datafile","category-rename-datafile"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=188"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/188\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=188"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}