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

Thread: Move of Rollback Tablespace datafiles

  1. #1
    Join Date
    Nov 2000
    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)?


  2. #2
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Apr 2000
    Edison, NJ
    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