Re: Exporting large DB

From: Kelly E. Harrelson <kharrels_at_interpath.com>
Date: 1996/06/07
Message-ID: <4p7v1i$pd0_at_news.interpath.net>#1/1


staction_at_ix.netcom.com(DANIEL OSIO) wrote:
>
>
>Hello/SOS
>
>Does anybody out there have experience with exporting large Oracle
>tables. I have been trying to export tables that exceed 2 GIG each
>and the export program does not seem to be able to handle this.
>After 12 long hours of exporting it comes back and asks for a
>second tape and shortly afterward it crashes with the following
>message
>
>EXP-0015 error on row ...
>EXP-00002 error writing file
> System message 22
>
>
>I have talked to ORACLE, SUN ( I am running on SUN OS 4.1.4 and ORACLE
>7.1.3) and just about everybody I can think of with NO result. Even
>ORACLE does not seem to be able to resolve this. Any advise is greatly
>appreciated ! Please respond to my office email at fe_at_lct.com
>
>
>Thank you.
>
>Frida Eliasdottir

Usually an error like that points to the device you're exporting to. (ex. out of space, bad permission, bad tape, ...). I'm not familiar with your configuration first-hand, but I would start looking at the OS and keep on Oracle to solve the problem or point you in the right direction.

Good Luck,

Kelly Harrelson Received on Fri Jun 07 1996 - 00:00:00 CEST

Original text of this message