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 ]
« Previous post
Next Post »
Let’s talk about what we can do for you.
Get our newsletter full of tips and trends delivered to your inbox.