Re: tablespace management
From: ddf <oratune_at_msn.com>
Date: Mon, 11 Jan 2010 06:45:36 -0800 (PST)
Message-ID: <111d86a2-6dea-4221-b701-112b24ccfff5_at_r5g2000yqb.googlegroups.com>
On Jan 11, 8:55 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> working in 10.2.0.4 enterpise on windows nt / have truncated many
> objects from a tablespace...rman backups reduced by 400g but can't
> shrink any datafiles..only 2 objects left in ts
>
> Please could you advise on options to free up physical space used / do
> i have to move the 2 objects or could i rebuild in situ
>
> regards
> Chris B
Date: Mon, 11 Jan 2010 06:45:36 -0800 (PST)
Message-ID: <111d86a2-6dea-4221-b701-112b24ccfff5_at_r5g2000yqb.googlegroups.com>
On Jan 11, 8:55 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> working in 10.2.0.4 enterpise on windows nt / have truncated many
> objects from a tablespace...rman backups reduced by 400g but can't
> shrink any datafiles..only 2 objects left in ts
>
> Please could you advise on options to free up physical space used / do
> i have to move the 2 objects or could i rebuild in situ
>
> regards
> Chris B
You will need to move the tables to a new, smaller tablespace to reclaim the storage as truncate does not reset the HWM for the datafile, only the table. Once moved you can drop the old tablespace including contents and datafiles, and reduce the disk footprint.
David Fitzjarrell Received on Mon Jan 11 2010 - 08:45:36 CST