| RBS tablespace wierd behaviour [message #60464] |
Mon, 09 February 2004 10:08  |
D e e p a n k a r
Messages: 9
Registered: October 2001
|
Junior Member |
|
|
Hi,
I created a new rollback segment tablespace and added new rollback segments to it, all are public and online.
I took all the other old rollback segments offline also took the tablespace offline.
After this when i started using the system, i was not able to insert data in few tables as they were trying to access the datafile for the old rollback segment which was offline. I resolved the issue by taking it ONLINE but was not able to understand why it was trying to access the Rollback segment tablespace.
I checked the RBS tablespace and it only had the rollback segments and no other extents.
Can anybody help
Any help is appreciated.
Thanks
Deep
|
|
|
|
|
|
| Re: RBS tablespace wierd behaviour [message #60467 is a reply to message #60465] |
Mon, 09 February 2004 20:17  |
Munish
Messages: 21
Registered: November 2001
|
Junior Member |
|
|
|
check ur old rollback segment. i mean before changing its status to offline, it was properly offlined, r u sure there was no active transation that time. if it is so then next time when u start machine next it didnt returned ny error????
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
