Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> defragment LOB tablespace
Hello All!
We need to reload some files into BLOB-tablespace. Unfortunatly it's impossible because tablespace hasn't one large flat free extent\segment but a lot of small ones scattered around all tablespace.
Are there any way or tools to defragment *existing* BLOB-tablespace? We havn't enough disk space to create new BLOB-tablespace to load (or move by clause 'ALTER TABLE .. MOVE another_tspace') BLOB-data into it.
Rgds, Vadim Grepan