I checked with the temp tablespace and and the containers in the tablespaces too. We have only 1 container in every tablespace according to our business rules so ther's no point of that error.
I am able to reorg some tables in the same tablespace while some are not being reorged.(without & with using "use <tablespacename>")
I am not able to figure out what the problem is.
can u do df-k and let me know how much free space left in the file system for temp tabspace? and also tablesize?
There should be double the space of the tablesize in tempspace for the reorg to be successful..so u have two options..create a new temp tablespace using new filesystem...or ask your system admin to add more space to u'r current filesystem.
I think cleanup option is for indexes and I didn't have any problem with reorging indexes. My problem is with tables and not all tables. I am not able to reorg not only large tables but also tables that have only 500 or so rows in it which don't require much space to reorg. Some tables were reorged without any problem.