×
Sign up

Tech Tip: Relocating Oracle DB Files

April 7, 2020

 

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 ]