Drop Table Reclaim Space

rubystep · #1 (**permalink**) 01-26-04, 11:32

During DROP TABLE activity which will remove catalog info relating to the table, DBA thought that also the pages in the tablespace would be reclaimed at the timr of the DROP.
Corret or incorrect?
DBA seems to be getting tablespace full condition despite having dropped the table. We're at UDB 8.1.3 64-bit.
TIA,
Ruby

cchattoraj · #2 (**permalink**) 01-26-04, 13:11

Are you using dms tablespaces?

rubystep · #3 (**permalink**) 01-26-04, 13:59

DMS tablespaces are used.

cchattoraj · #4 (**permalink**) 01-26-04, 14:06

Do you have multiple tables in the tablespace?

rubystep · #5 (**permalink**) 01-26-04, 19:18

Yes, multiple tables in the tablespace.

nitingm · #6 (**permalink**) 01-27-04, 02:24

Hi,

Try asking the dba to use reorg command that will definitely reclaim as much as space as possible.

Regards

nitin.

platho · #7 (**permalink**) 01-27-04, 09:17

Quote:

Originally posted by nitingm
Hi,

Try asking the dba to use reorg command that will definitely reclaim as much as space as possible.

Regards

nitin.

Hi ,

Perhaps a very stupid question, but if a table is dropped, how can you do a reorg on it ? Can you do a reorg on a tablespace ?

I hope someone can answer this because I am struggling with the same problems ...