Re: off the wall ideas welcomed
Date: Wed, 4 Feb 2009 09:41:38 -0500
Have you tried to export the table directly into a compressed file?
mknod dbpipe p
gzip < dbpipe > export.dmp.gz &
On Feb 4, 2009, at 9:26 AM, Niall Litchfield wrote:
> 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
> the date of corruption is unknown, so PIT recovery will be tricky of
> alter table move lob... doesn't work because it also tries to
> rebuild the table segment which is not allowed because of the long
> 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