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

Graeme,
Thanks, but I know that :-)
The data files aren't larger than 2GB, but the tablespaces are, therefore I already do an export to pipe with a compress on all tablespaces.

Graeme Farmer wrote:

> 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 Wed Apr 19 2000 - 00:00:00 CDT