Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Archive for the 'DBA Administration' Category

Move the datafile into the new location

Posted by Mir Sayeed Hassan on 27th September 2017

Move the datafiles (System, SYSAUX, UNDOTBS, TEMP, REDO LOGFILES) into the new location: ======== USERS TBS ========= Note: It does not require the database to be bonce or in mount stage for USERS tablespace Get the datafile location exist SQL> select name from v$datafile;     (Old Location of al the… Read more..

Posted in DBA Administration | Comments Off on Move the datafile into the new location