-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|