-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|