RE: Reallocate Table Storage

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Thu, 04 Oct 2001 12:10:09 -0700
Message-ID: <F001.003A244B.20011004115033@fatcity.com>

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 ... <set new storage>

Or you could create table as as select <new table name>, 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_at_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_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 - 14:10:09 CDT