Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    5

    Question Unanswered: -2147217873 ora-01110 ora-01578

    Hi i have the the following err msg while updating a remote database..
    -2147217873 ....ora-01110...ora-01578..from the oracel err msg, it seems the block is corruptted..not really understand wat is this...i am using VB6 ADODB recordset with .Addnew and .update to create a new record....

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: -2147217873 ora-01110 ora-01578

    Originally posted by zkkee
    Hi i have the the following err msg while updating a remote database..
    -2147217873 ....ora-01110...ora-01578..from the oracel err msg, it seems the block is corruptted..not really understand wat is this...i am using VB6 ADODB recordset with .Addnew and .update to create a new record....
    Here's the full explanation from Oracle docs. You'll need to pass this on to your DBA.

    ORA-01578 ORACLE data block corrupted (file # string, block # string)

    Cause: The data block indicated was corrupted, probably due to program errors.

    Action: Determine which object was corrupted using a command like the following:

    SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS
    WHERE file = FILE_ID AND block BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;

    where values for file and block are from the message.

    Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services.

  3. #3
    Join Date
    Oct 2002
    Location
    Singapore
    Posts
    5

    Re: -2147217873 ora-01110 ora-01578

    thanks andrew

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •