Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error Exporting Tables

10 views
Skip to first unread message

Gene Dershewitz

unread,
Mar 24, 1997, 3:00:00 AM3/24/97
to

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

Jensen Langford - Sun UK - Contractor

unread,
Mar 25, 1997, 3:00:00 AM3/25/97
to

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?

Ken Shirey

unread,
Apr 2, 1997, 3:00:00 AM4/2/97
to


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

0 new messages