Recovering Free Space in Oracle 9i

greenspun.com : LUSENET : DBAzine : One Thread

We have a Oracle 9i database which had a large amount of large binaries stored in it. We were able to delete these binaries and now want to recover the unused space in the BLOB tablespace. My question is, is there a way to do this without doing an export/import operation? If export/import is the only option can anyone point me to a good write up on this procedure and any metrics on how long this operation would take on a 18G database?

Thanks in advance,

Mike Sweet

-- Michael K. Sweet (msweet@infoatom.com), May 18, 2004


Moderation questions? read the FAQ