Reallocate Table Storage

From: Jeff Wiegard <JWIEGARD_at_ngwmail.des.state.mn.us>
Date: Thu, 04 Oct 2001 11:30:47 -0700
Message-ID: <F001.003A22C0.20011004105523@fatcity.com>

good day ...

I'm looking at a production, test, development environment tight on space. I've noticed there are a slew of tables that aren't used at all, or are improperly sized. In fact, I could recapture perhaps 20 percent of the "used space", which measures in the gigabyte range. I have an idea of how I want to do this, but thought I'd post for how others have accomplished this.

thanks,

Jeff
--

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

Author: Jeff Wiegard
  INET: JWIEGARD_at_ngwmail.des.state.mn.us

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 Thu Oct 04 2001 - 13:30:47 CDT