×
1-888-308-ERP1

Tech Tip: Relocating Oracle DB Files

December 17, 2019

 

Starting with Oracle 12.1, you can relocate Datafile ONLINE with no need to shutdown the database,

ALTER DATABASE MOVE DATAFILE ( ‘filename’ | ‘ASM_filename’ | file_number )

[ TO ( ‘filename’ | ‘ASM_filename’ ) ]

[ REUSE ] [ KEEP ]