Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How resize rollback segment

Re: How resize rollback segment

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 15 Sep 2000 12:56:41 -0400
Message-Id: <10620.117139@fatcity.com>


Yes.
alter rollback segment rbx offline;
drop rollback segmrnt rbx;
create rollback segment ......;
alter rollback segmrnt rbx online;
ROR
>>> cemail_at_sprintmail.com 09/14/00 07:12PM >>>

How can you make a particular rollback segments total size larger?  It is currently at 500MB and I want make it 1000MB.



Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!

--=20
Author:=20
  INET: cemail_at_sprintmail.com=20

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: ListGuru_at_fatcity.com (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). Received on Fri Sep 15 2000 - 11:56:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US