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