RE: Re: ORA-01578: ORACLE data block corrupted
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <po04541@xxxxxxxxx>, "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2010 10:59:22 -0600
Google is your friend. Well, if you're not in China.
http://www.dbaxchange.com/3_4_longdatatypes.htm
hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of patrick obrien
Sent: Tuesday, March 23, 2010 10:49 AM
To: Oracle L
Subject: Fw: Re: ORA-01578: ORACLE data block corrupted
Hmm,
now I"m trying to copy this table using the create table as select and
it does not like my LONG data type, any thoughts, thank you!
SQL> exec DBMS_REPAIR.SKIP_CORRUPT_BLOCKS('AMS_AFINADM','AD_OBJATCH');
PL/SQL procedure successfully completed.
SQL> CREATE TABLE AMS_AFINADM.AD_OBJATCH_NEW
AS SELECT * FROM AMS_AFINADM.AD_OBJATCH;
2 AS SELECT * FROM AMS_AFINADM.AD_OBJATCH
*
ERROR at line 2:
ORA-00997: illegal use of LONG datatype
--- On Mon, 3/22/10, Saurabh Sood <email2sood@xxxxxxxxx> wrote:
From: Saurabh Sood <email2sood@xxxxxxxxx>
Subject: Re: ORA-01578: ORACLE data block corrupted
To: po04541@xxxxxxxxx
Cc: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, March 22, 2010, 11:33 PM
Hi,
You can use event 10231 to complete the import process.
refer to following link for the complete resolution of ora-1578:
http://askdba.org/weblog/2008/05/ora-1578-ora-8103-corruption/
Cheers!!!
Saurabh Sood
On Tue, Mar 23, 2010 at 3:04 AM, patrick obrien <po04541@xxxxxxxxx>
wrote:
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.
--
SAURABH SOOD
ORA-DBA
Other related posts:
- » RE: Re: ORA-01578: ORACLE data block corrupted - Sweetser, Joe
