Move of Rollback Tablespace datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Move of Rollback Tablespace datafiles

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    I know how to move (using rename) datafiles belonging to regular tablespaces. What I would like to know is if I am changing the location of datafiles belonging to the rollback tablespace how do I go about doing it? Is it similar as for system (where the db is in mount stage)?

    Thanks,
    Nirasha

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    SYSTEM, you definitely have to be in MOUNT mode. RBS, I'm not sure, but as long as you are in MOUNT mode, I'd do it then...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    It's better to do it just the way for System dbf. You can attempt to do this when the db is running, but if a rbs is active, you will not be able to take the ts offline and if successful, a user will get an error if a transaction is carried out when the ts is offline.

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