Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete STATSPACK data efficient to release back space?

Re: How to delete STATSPACK data efficient to release back space?

From: DR <cichomitiko_at_gmail.com>
Date: Fri, 6 Jan 2006 13:42:54 +0100
Message-ID: <43be65c9$0$15785$14726298@news.sunsite.dk>


"Rene" <rvangeijn_at_tiscali.nl> ha scritto nel messaggio news:1136539370.468041.193490_at_f14g2000cwb.googlegroups.com... > $ORACLE_HOME/rdbms/admin/sppurge.sql

>> I want to delete a bunch of data and resize the tablespace back.
>> But in my past experience with this same database, I notice, even if I
>> delete like 1 months's data, look like the new data is not going in the
>> "delete space" and my tablespace's size keep growing..
>>
>> Any good idea??

Backup the data (export owner=perfstat ...) if you need it and then run $ORACLE_HOME/rdbms/admin/sptrunc.sql .

Regards,
Dimitre Received on Fri Jan 06 2006 - 06:42:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US