Saturday, January 23, 2010

Renaming Oracle files

This can be handy to move non current redo logs from a currupt location.
to a new location.


alter database RENAME FILE '/dir/redo.log' to '/newdir/redo.log';



******************************************
keywords:
******************************************
rdbms version:
******************************************

No comments: