Thanks for the info. It's 8.1.7.4, and it's not hard-coded. I changed it from 50% to 0%, but the damage had been done. Maybe you're just nostalgiac for the good old days of v6!
I did set an optimal, and used shrink. That worked fine to shrink the segments, but they are still scattered throughout the tablespace, preventing me from resizing the datafile. Thanks, Mike -----Original Message----- Sent: Monday, November 17, 2003 2:44 PM To: Multiple recipients of list ORACLE-L Michael Milligan wrote: > > I have a client where rollback segments were set up RBS01-RBS05, all in a > tablespace called RBS. The person who set it up set %INCREASE at 50%. Well, > I shrank the segments to themselves down to less than 500MB total from > 4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let > me resize it at all (it has extents scattered throughout). Anyone know how I > go about shrinking it? Do I have to create a new tablespace/datafile, then > drop the old one? > > TIA, > > Michael Milligan > Oracle DBA > Ingenix, Inc. > 2525 Lake Park Blvd. > Salt Lake City, Utah 84120 > wrk 801-982-3081 > mbl 801-628-6058 > [EMAIL PROTECTED] > Waow !!! A true, live Oracle 6 database ? AFAIK, PCTINCREASE has been hard-coded to 0 for rollback segments since the beginnings of Oracle 7. Concerning your question, it all depends on where your existing rollback segments are located in the datafile (look at dba_extents). All you have to do is drop and recreate each roolback segment in tirn. Now, if this really is an Oracle6 database, RESIZE doesn't work ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).