RE: Re: ORA-01578: ORACLE data block corrupted

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: