I need to rename a datafile. I will have to take a tablespace offline.
How do I check if tablespace is being currently used? Are there any other procausions I need to take?
That would be my first step. Next steps as follows:
-alter tablespace /tablespace name/ offline;
-rename through OS.
-alter tablespace rename datafile...
-alter tablespace online.
Please let me know if what I am about to do is a right scenario.
A Winner never Quits, A Quitter never Wins