Re: off the wall ideas welcomed
- From: japplewhite@xxxxxxxxxxxxx
- To: niall.litchfield@xxxxxxxxx
- Date: Wed, 4 Feb 2009 08:36:43 -0600
Use the Query parameter of exp to get small enough parts of the table so
that the successive *.dmp files cam be zipped up and moved?
Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9715 (wk) / 512.935.5929 (pager)
Niall Litchfield <niall.litchfield@xxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
02/04/2009 08:30 AM
Please respond to
niall.litchfield@xxxxxxxxx
To
ORACLE-L <oracle-l@xxxxxxxxxxxxx>
cc
Subject
off the wall ideas welcomed
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:
