Re: off the wall ideas welcomed

the core problem isn't the size of the export file - it's that the lobindex on the lob column is corrupt. I just mention the export size since it seems extremely unlikely to me that the data for this table really occupies over 2gb. It is of course possible that it is since dba_segments won't report the size of the lob in the size of the table, but still 5000 html docs shouldn't really be 2gb in size..

On Wed, Feb 4, 2009 at 2:26 PM, Niall Litchfield <niall.litchfield_at_gmail.com
> wrote:

> list
>
> I have an old 9i database with a table that appears to have been used as a
> test bed for as many oracle features as possible! In particular this table
> has
>
> a fine grained access control policy
> a long raw column
> a blob column
>
> The lob index is now corrupt. The recommended action is to export the
> table, drop the table and reimport - however the export file for this 12mb
> table grows to at least 2.4gb at which point disk space is exhausted.
>
> the date of corruption is unknown, so PIT recovery will be tricky of
> possible!
>
> alter table move lob... doesn't work because it also tries to rebuild the
> table segment which is not allowed because of the long raw.
>
> SQLPLUS copy doesn't work because of the 'object types' - presumably the
> BLOB.
>
> I'm pretty much out of (cheap) ideas for dealing with this corruption right
> now, so would welcome some.
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l