Re: Error Exporting Tables

User receiving >>
 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.

There were some bugs with the import/export utilities around 7.1.4 and 7.1.5. But before calling Oracle check that you can try the following:

1. select * from table_name -- this should verify the table
2. Run the analyze table validate structure cascade command against the table. Oracle support will ask for this and it will validate what select * would miss
3. verify that the export output file system did not fill up during the export
4. Check the error manaul or use the oerr utility to see what each of the above messages mean just ain case
5. if the problem has not been determined, call Oracle support and ask about all patches for import/export for 7.1.4

With luck someone who remember the bug# will see your post and respond. Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Tue Mar 25 1997 - 00:00:00 CST