Hi, All,
I have the Standard Edition oracle for our production database in my office.
I am needing to move datafiles from a filesystem to another but with no shutdown my production database.
And, during my searches, I have found no recomendations -- before moving them -- to turn its tablespaces offline.
Example:
SQL> alter database rename file '/prev/oracle/prod1.dbf' to '/new/oracle/prod1.dbf';
Database altered.
SQL> recover datafile '/new/oracle/prod1.dbf';
Media recovery complete.
SQL>_
SQL> alter database datafile '/new/oracle/prod1.dbf' online;
Database altered.
SQL>_
Do I need to turn my tablespaces offline before move my datafiles?
I appreciate any advices.
Thanks, in advance.
Luiz Cássio