Rename DataFile The procedure of renaming an Oracle datafile is actually the same as the procedure of moving datafile with a different file name. Let's… Read More »How Oracle Rename DataFile
Empty a Database In my case, a phased out database server is going to transfer to another project team, my job is to remove all… Read More »How to Empty an Oracle Database
Move Tablespace by RMAN No like we move individual data file to another place by RMAN, changing the location of a tablespace by RMAN is… Read More »Switch Tablespace To Copy
Move Data File Offline Not like the new released statement ALTER DATABASE MOVE DATAFILE which can move data files online, the old-fashioned file renaming procedure… Read More »Alter Database Rename File