Re: ORA-01578: ORACLE data block corrupted
- From: Harel Safra <harel.safra@xxxxxxxxx>
- To: "po04541@xxxxxxxxx" <po04541@xxxxxxxxx>
- Date: Tue, 23 Mar 2010 00:58:33 +0200
You have a corrupted block in the table you're exporting.
Your best bet is to get in touch with Oracle support, maybe they can help
you salvage the data.
Harel
(From my phone, excuse the terseness)
ב-22/03/2010, בשעה 23:34, patrick obrien <po04541@xxxxxxxxx> כתב/ה:
Hello my good oracle friends,
( to start out, thanks for all of your help with my past problems. )
Oracle Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
I've got the following importing, not sure the best fix?? thank you!
Mead:oracle$ exp parfile=AD_OBJATCH.par
Export: Release 8.1.6.2.0 - Production on Mon Mar 22 14:27:16 2010
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production
With the Partitioning option
JServer Release 8.1.6.2.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
About to export specified tables via Conventional Path ...
Current user changed to AMS_AFINADM
. . exporting table AD_OBJATCH
EXP-00056: ORACLE error 1578 encountered
ORA-01578: ORACLE data block corrupted (file # 54, block # 345609)
ORA-01110: data file 54: '/u10/dbs/fsco/object02.dbf'
Export terminated successfully with warnings.
Other related posts:
