I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this tablespace).
Question: Is there a way to reduce the size of a tablespace after we drop a big table in that tablespace ?
February 5, 2009 5:11 PM
February 10, 2009 8:50 PM