they got rid of it, I think they brought it back for a while, then got rid of it again... always confused the heck out of me.. which is why I script and reuse create database stuff.
You people think I KNOW this stuff? Ha! I just have a REALLY good collection of scripts <G> --- Ron Thomas <[EMAIL PROTECTED]> wrote: > > FYI- > > FWIR, it is no longer required to create a second rollback segment in > SYSTEM at database creation. > This requirement was removed at version 8 (or possibly even 7.3.4). > > Ron Thomas > Hypercom, Inc > [EMAIL PROTECTED] > If A = B and B = C, then A = C, except where void or prohibited by > law. -- Roy Santoro > > > > > [EMAIL PROTECTED] > > To: > [EMAIL PROTECTED] > > 08/28/02 11:53 AM cc: > > Please respond to Subject: RE: How to > increase maxextents of ROLLBACK segment_type? > ORACLE-L > > > > > > > > > > hm, it might be that I was thinking of the "second" rollback segment > you had to create in the system tablespace before you could create > any > other tablespaces.... > > remove that "might", that sounds more along the lines of what I was > thinking. > > sorry for the confusion. I bow to the "redo/undo/rollback" expert > > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > Before taking the system rbs offline, contact tech support. I > recall > > (perhaps incorrectly...I don't remember whether or not I have > tested > > this) > > that the system rbs is used by the kernel for normal operations and > > by other > > transactions if the other rbs are too full. The system rbs should > > never be > > specifically allocated to a transaction by a user. > > > > Always create additional rollback segments in a separate > tablespace. > > If you > > fill up the rbs tablespace, the transaction fails. If you fill up > the > > system > > tablespace, the database fails. > > > > -----Original Message----- > > Sent: Wednesday, August 28, 2002 7:23 AM > > To: Multiple recipients of list ORACLE-L > > > > > > create a rollback tablespace, create new rollback segments IN the > > rollback tablespace and take the rollback segment named "SYSTEM" > > offline. Do NOT use it. > > > > Having an active rollback segment in your system tablespace is like > > allowing users to create objects there. Especially listen to > Stephane > > and READ the manuals. You should not be increasing the allowable > size > > of that segment, it should be tiny and unused. > > > > > > --- Jonny Delmont <[EMAIL PROTECTED]> wrote: > > > > > > Mark, > > > Thanks, your command doesn't help. To answer your question, > > Database > > > was setup'd by previous DBA. Still i've never seen this type of > > > segment... > > > SQL> alter rollback SEGMENT sys.system storage (maxextents 1024); > > > alter rollback SEGMENT sys.system storage (maxextents 1024) > > > * > > > ERROR at line 1: > > > ORA-02244: invalid ALTER ROLLBACK SEGMENT option > > > > > > Jonny > > > Mark Leith <[EMAIL PROTECTED]> wrote: Do you mind if I ask > > why? > > > Do you have any other rollback segments in place > > > other than the SYSTEM one? > > > > > > In answer to your question though, look at the error message.. > You > > > missed > > > out the word "segment". > > > > > > alter rollback SEGMENT sys.system storage (maxextents 1024); > > > > > > HTH > > > > > > Mark > > > > > > =================================================== > > > Mark Leith | T: +44 (0)1905 330 281 > > > Sales & Marketing | F: +44 (0)870 127 5283 > > > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > > > =================================================== > > > http://www.cool-tools.co.uk > > > Maximising throughput & performance > > > > > > -----Original Message----- > > > Sent: 28 August 2002 10:53 > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Dear Gurus, > > > Could you please help me out with this - I want to increase the > > > maxextents > > > of below segment. > > > TIA, > > > SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS > > > 2 from dba_segments > > > 3 where ((max_extents-extents)/max_extents)*100 <40 and > max_extents > > > != 0 > > > 4 / > > > OWNER SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS > > > ------ --------------- ------------------ ---------- ----------- > > > SYS SYSTEM ROLLBACK 505 505 > > > SQL> connect sys > > > Enter password: > > > Connected. > > > SQL> alter ROLLBACK sys.system storage (maxextents 1024); > > > alter ROLLBACK sys.system storage (maxextents 1024) > > > * > > > ERROR at line 1: > > > ORA-01902: SEGMENT keyword expected > > > > > > TIA > > > Jonny > > > > > > > > > > > > > > > > > > Get a bigger mailbox -- choose a size that fits your needs. > > > > > > http://uk.docs.yahoo.com/mail_storage.html > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Mark Leith > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing Lists > > > > > > -------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You > may > > > also send the HELP command for other information (like > > subscribing). > > > > > > > > > > > > --------------------------------- > > > Get a bigger mailbox -- choose a size that fits your needs. > > > > > > http://uk.docs.yahoo.com/mail_storage.html > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Finance - Get real-time stock quotes > > http://finance.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California -- Public Internet access / Mailing > > Lists > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).