How i can free space in tablespace

External Since: Oct 08, 2008 Posts: 1

I delete from large table over 50 million record, but snapshot monitor
show that the used pages not changed. Reorg take error "to small free
space in tablespace to complete reorg"

External Since: Sep 15, 2003 Posts: 225

v_laptev2001.DeleteThis@mail.ru wrote:
> I delete from large table over 50 million record, but snapshot monitor
> show that the used pages not changed. Reorg take error "to small free
> space in tablespace to complete reorg"

Without enough free space in the tablespace, you have to specify a
temporary tablespace to use for the reorg. As in, 'reorg table ...
use tempspace1'.