Re: shrinking space
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Wed, 01 Jun 2011 20:30:15 +1000
Message-ID: <4DE614B7.6070003_at_iinet.net.au>
Nuno Souto wrote,on my timestamp of 1/06/2011 8:12 PM:
> If you are really pressed for disk space, I'd suggest:
> delete offending rows,
> export the table,
> truncate it,
> then import with ignore=y and destroy=n so that it doesn't change anything in
> the current allocation or grants, just loads rows.
Date: Wed, 01 Jun 2011 20:30:15 +1000
Message-ID: <4DE614B7.6070003_at_iinet.net.au>
Nuno Souto wrote,on my timestamp of 1/06/2011 8:12 PM:
> If you are really pressed for disk space, I'd suggest:
> delete offending rows,
> export the table,
> truncate it,
> then import with ignore=y and destroy=n so that it doesn't change anything in
> the current allocation or grants, just loads rows.
Oh, my apologies:
add one step to drop any indexes on the table before importing.
You do *NOT* want to import a large number of rows on a heavily indexed table,
if that be the case.
-- Cheers Nuno Souto in rainy Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 01 2011 - 05:30:15 CDT