Re: off the wall ideas welcomed

From: Bill Zakrzewski <bill_at_intactus.com>
Date: Wed, 4 Feb 2009 09:41:38 -0500
Message-Id: <4B12AEFE-40F9-4BA4-80A2-E22EA37A3DF5_at_intactus.com>

Have you tried to export the table directly into a compressed file?

mknod dbpipe p
gzip < dbpipe > export.dmp.gz &

exp file=dbpipe.......

-Bill
On Feb 4, 2009, at 9:26 AM, Niall Litchfield 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

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

Received on Wed Feb 04 2009 - 08:41:38 CST