RE: Reallocate Table Storage

From: Jeff Wiegard <JWIEGARD_at_ngwmail.des.state.mn.us>
Date: Thu, 04 Oct 2001 12:20:53 -0700
Message-ID: <F001.003A24DE.20011004120025@fatcity.com>

Thanks. Leaves are at their peak, but it's about to get COLD! Temp in the upper 20's when we wake up Saturday morning.

>>> "Koivu, Lisa" <lisa.koivu_at_efairfield.com> 10/04/01 02:00PM >>>
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).

-- 
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:20:53 CDT