Originally posted by helpme
I just create a new database and i c that that the rbs table space is already using 50 Mb space..
How is it possible?
The existing rollback segments you have created at database creation take this space. Count the number of rollback segments in that tablespace, multiply this with inital extent size multiplied by MINEXTENT and you'll get 50MB.
Can i empty this table space?
Only by dropping some of the rollback segments..
[Edited by jmodic on 07-11-2001 at 09:34 AM]
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?