rename datafile

[mary]

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;
-alter tablespace rename datafile...
-rename through OS.
-alter tablespace online.
Please let me know if what I am about to do is a right scenario.

[Kishore]

Yes. What you are doing is right. Go ahead.

[aarganesh]

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;
***CHECK HERE***
-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.
Regards
Ganesh .R

[Halo]

1. take ts offline
2. rename/move the dbf in question
3. rename the dbf for Oracle
4. bring ts online