From lisa.koivu@efairfield.com Thu, 04 Oct 2001 12:10:09 -0700 From: "Koivu, Lisa" Date: Thu, 04 Oct 2001 12:10:09 -0700 Subject: RE: Reallocate Table Storage Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Reallocate Table Storage Hi Jeff, Well if you have the time, export/import and reset your storage parms either in the dump file or with LMT's Or you can alter table move ... Or you could create table as as select , drop initial table and rename new table.  These are just a few options. How's beautiful Minnesota?  I read that the leaves peaked last week.  Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 -----Original Message----- From:   Jeff Wiegard [SMTP:JWIEGARD@ngwmail.des.state.mn.us] Sent:   Thursday, October 04, 2001 2:55 PM To:     Multiple recipients of list ORACLE-L Subject:        Reallocate Table Storage 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@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@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).