RE: System Tablespace > 1.5 GB

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Mon, 18 Dec 2000 10:22:22 -0500
Message-Id: <10714.124841@fatcity.com>

Hi Volker,

alter database datafile '<filename>' resize nnn M=20

• Jerry

-----Original Message-----
From: Schoen Volker [mailto:v.schoen_at_inplan.de] Sent: Monday, December 18, 2000 7:41 AM
To: Multiple recipients of list ORACLE-L Subject: System Tablespace > 1.5 GB

Hi list,

I have a costumer, which has a system tablespaces with 1.2 GB. Default storage parameter fpr initial and next extent are 102400 KB. My = question,
how can I minimize and reorganize system tablespace, Full DB export? Or = is
there another easier method?

TIA Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

--=20

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

Author: Schoen Volker
  INET: v.schoen_at_inplan.de

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 Mon Dec 18 2000 - 09:22:22 CST