Re: off the wall ideas welcomed
Date: Wed, 4 Feb 2009 09:41:49 -0500
Try to export it remotely where there is plenty of space...
Exp user/pass_at_your_db file=/disk_with_alot_of_space/file.dmp
On Feb 4, 2009, at 9:26, Niall Litchfield <niall.litchfield_at_gmail.com> 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