Tuesday, December 22, 2015

Alter database: Move or Rename a Database File or Online Redo Log

NOTE - The database must be mounted to rename or move online redo logs. The database must be mounted or the data files taken offline to move database data files.
ALTER DATABASE RENAME FILE '/ora/datafile/oldfile.dbf' TO '/ora/datafile/newfile.dbf';

No comments: