cleaning up rollback segments

From: Doug Cowles <dcowles_at_i84.net>
Date: 2000/04/17
Message-ID: <38fa692d.18625480@news.remarq.com>#1/1

I've got a development database where the rollback segments were all created in the SYSTEM tablespace. They were, SYSTEM, R0, R01,R02,R03 & R04. I moved R01-4 into their own tablespaces. However, I wasn't sure what to do with SYSTEM, and R0. Isn't R0 the default system rollback segment? Or in this case is it SYSTEM?. How do I know which rollback segment the database is using for it's SYSTEM rollback segment? I could of sworn I've seen R0 ususally. Oracle 8.1.5 on AIX. 4.3.2

-Dc. Received on Mon Apr 17 2000 - 00:00:00 CDT