Re: shrinking space

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 01 Jun 2011 20:30:15 +1000

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@xxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l


Other related posts: