#1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2002
    Posts
    26
    Rep Power
    0

    Unhappy Oracle error: ORA-27069


    Hi All,

    Getting the error messages below when attempting to access
    a certain record. Has anyone seen this before or can anyone
    provide more info on what might be the cause and how to correct
    it? I looked it up and said it's caused when the device where
    data resides is offline, but I don't believe that's the case
    here, as the rest of the database appears to be working fine.

    The following error has occurred:

    ORA-01114: IO error writing block to file 4 (block # 793986)
    ORA-27069: skgfdisp: attempt to do I/O beyond the range of the
    file
    OSD-04026: Invalid parameter passed. (OS 793986)


    The error occurs only on a particular record...

    Any help on this would be much appreciated.


    Thanks,

    Sgaucho
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    From Google:
    ORA-01114: IO error writing block to file name block # num
    Cause: The device on which the file resides is probably off line.

    Action: Restore access to the device, then retry the operation.
    Check for offline files! Check also the size of the file, it might be too big.

    Take a look also on Metalink.

IMN logo majestic logo threadwatch logo seochat tools logo