Re: off the wall ideas welcomed
- From: Bill Zakrzewski <bill@xxxxxxxxxxxx>
- To: niall.litchfield@xxxxxxxxx
- 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 &
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
Other related posts:
