Apps DBA Workshop

Rename/Move data file online - This is the first new feature I am demonstration on Oracle database 12c new features. This is really a wonderful feature. You cannot only move datafiles  form one location to another on normal file system, you can even move your datafiles  from NON-ASM to ASM Diskgrups: In this article I will demonstrate rename/move : 1) Normal rename of datafille 2) Rename from normal location to ASM 3) Move from one ASM location to another 4) Move from ASM to Non-ASM 1) Normal rename of datafille SQL> SQL> select name, STATUS  from v$datafile; NAME                                                         STATUS -------------------------------------------------...