It looks like your data file resides on a raw device, how big is this
device?, (I think there is a 2GB maximum file size.)
Have you checked the permissions?
Check with your SYSADMIN, what the largest file is that can be handled.
Do other databases, datafiles use the same device?
Can you view, select. insert from SQLPLUS into this table?
Does the database start/stop ok?
Gene Dershewitz <gen...@teleport.com> wrote in article
<5h6245$bsq$1...@nadine.teleport.com>...
> On an Oracle 7.1.4 system, we just started developing the a problem with
a
> nightly database dump. Only one particular database has the problem and
all
> except a few small tables fail to export with the following errors:
>
> . exporting table ANIMAL
> EXP-00014: error on row 1 of table ANIMAL
>
> EXP-00222:
> System error message 2
> EXP-00008: ORACLE error 1116 encountered
> ORA-01116: error in opening database file 4
> ORA-01110: data file 4: '/dev/rr01'
> ORA-07209: sfofi: file size limit was exceeded.
>
> Can anyone tell me where to start with this??
>
> --Gene Dershewitz
> gen...@teleport.com
>
I am guessing that datafile 4 (/dev/rr01) is a rollback segment datafile.
Are you doing a CONSISTENT=Y export? If so, try putting on a larger
rollback segment.
If datafile 4 does not contain rollback segments, can you successfully
shutdown and restart
the database? How big is file 4? What operating system (HP/UX, Solaris,
etc) are you using?
Please repost answers or email me @ shi...@flash.net