Tech Tip: Relocating Oracle DB Files

1 min read
  • Tech Tips

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 ]