RE: ALTER ROLLBACK SEGMENT rbs SHRINK

From: Sandeep Kurliye <Sandeep_at_almoayyedintl.com.bh>
Date: Tue, 29 Jan 2002 23:51:38 -0800
Message-ID: <F001.003FFFAF.20020129235022@fatcity.com>

I don't think - it will work. You won't get any error as well as it won't shrink.

Any other inputs from others???

Rgds,

-----Original Message-----
Sent: Wednesday, January 30, 2002 9:55 AM To: Multiple recipients of list ORACLE-L

Hi,

Assume

INITIAL * MINEXTENT = 2M and also = OPTIMAL

Do you think

ALTER ROLLBACK SEGMENT rbs SHRINK TO 1M;

will work ?

Thanks,

Sinardy
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sinard Xing
INET: sinardyxing_at_bcs-ach.com.sg

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Sandeep Kurliye
INET: Sandeep_at_almoayyedintl.com.bh

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------