rename datafile
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rename datafile

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Cool

    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.

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Yes. What you are doing is right. Go ahead.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Jun 2000
    Location
    Chennai/India
    Posts
    90
    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
    A Winner never Quits, A Quitter never Wins
    Ganesh .R

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    1. take ts offline
    2. rename/move the dbf in question
    3. rename the dbf for Oracle
    4. bring ts online

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width