Oracle 12c Datafile moved Online
--------------------------------------------
In 12.1.0, a data file can now be moved online while it is open and being accessed, all these are possible now:
- Renaming an Online Datafile
- Relocating an Online Datafile
- Copying an Online Datafile
- Relocating an Online Datafile and Overwriting an Existing File
- Relocating an Online Datafile to Oracle ASM
- Moving a File from One ASM Location to Another ASM Location
Command :-
>>>>alter database move datafile ‘old_location’ to ‘new_location';
>>>>select file_name from dba_data_files;
Happy Learning
--Sreene
|
Such as very good information promoting content are provided and more skills are improved after refer that post.
SQL DBA Training in Chennai