Re: Export fails with ORA-01115 and ORA-27072 Errors

You cannot export datafiles larger than 2GB. Don't know the ins and outs of why this is so but I also had this problem when exporting to filesystem. Try exporting to a pipe which compresses the file or to tape (which is very slow...).

Graeme Farmer.
AIX System Administrator/Oracle DBA.

Yes wrote in message <38FDE566.365C1DDC_at_ibm.net>...
>Running Oracle 8.0.5.2 on Solaris 2.7
>
>When performing a full export of the database last night, I received the
>following error:
>
>EXP-00056: ORACLE error 1115 encountered
>ORA-01115: IO error reading block from file 12 (block # 262144)
>ORA-01110: data file 12: '/apps/ora_disk04/PROD/prod04.dbf'
>ORA-27072: skgfdisp: I/O error
>SVR4 Error: 25: Inappropriate ioctl for device
>Additional information: 262143
>
>I did my research, and have yet to find the reason for this error.
>I also tried to run the dbv program against the hotbackup of this
>particular datafile, but because it's 2 Gigs in size this utility does
>not seem to work...
>Always get DBV-00100: Specified FILE <> not accessible (and I recieve
>this error for any file that's 2GB in size).
>
>TIA for any help
>
>
Received on Thu Apr 20 2000 - 00:00:00 CDT