Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to delete STATSPACK data efficient to release back space?
"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
![]() |
![]() |