Re: System tablespace growing

>>>>> "Frank" == Frank <fvanbortel_at_netscape.net> writes:

>> = 'SYSTEM' / On more than one occastion I have found rollback
>> segments in there. With the exception of the SYSTEM rbs, get them
>> out. They are probably left over from database creation, or were
>> accidentally imported into that tablespace if you ever did a full
>> import and did not create the tablespace they were originally
>> exported out of first.

 Frank> I see that popping up in scripts every now and then, and it's
 Frank> totally unnecessary to create rollback segments in the system
 Frank> tablespace before creating tablespaces.  And it has been since
 Frank> 7.1, iirc.

I think you do still need to create an additional RBs in SYSTEM during database creation if you also want to use LMT for your rollback segments. You don't need to do it if your using DMT for your rollback segments though.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!