Rollback datafile size

From: Michael Milligan <Michael.Milligan_at_ingenix.com>
Date: Mon, 22 Dec 2003 11:54:32 -0800
Message-ID: <F001.005DAA72.20031222115432@fatcity.com>

The datafile for our rollback segments gre huge because of an improper setting. Even setting optimal and shrink, etc., won't help because the segments are scattered. Do I have to create a new tablespace? Can I change the datafile a rollback segment writes to and then take the other offline?

The datafile is 4.6 GB but the segments are small, so all that space is wasted. Any help would be appreciated. I'm trying to read up more, but have found nothing about what to do when shrink won't work.

Thanks,

Michael Milligan
Oracle DBA
Ingenix, Inc.
2525 Lake Park Blvd.
Salt Lake City, Utah 84120
wrk 801-982-3081
mbl 801-628-6058
michael.milligan_at_ingenix.com

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: Michael.Milligan_at_ingenix.com

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: 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 Mon Dec 22 2003 - 13:54:32 CST