Re: ORA-03113 while exporting

From: Thomas Fox <belvdr_at_yahoo.com>
Date: Tue, 11 Oct 2005 13:54:41 -0700 (PDT)
Message-ID: <20051011205441.10044.qmail@web32405.mail.mud.yahoo.com>

I'm not sure it would have any effect, but are you using direct=y in your export as sys?

The only other two things that I can think of is:

Using an earlier version of exp to do this on 9.2.0.6.
The database is somehow crashing or restarting when this happens.

--Tom

Gabriel Hanauer <gabriel.hanauer_at_gmail.com> wrote:

> Database is 9.2.0.6.0 running on a windows 2000 server.
>
> Every time when a try to do a full export of the database the following error
> occurs:
>
> . exporting foreign function library names
> . exporting PUBLIC type synonyms
> EXP-00008: ORACLE error 3113 encountered
> ORA-03113: end-of-file on communication channel
> EXP-00000: Export terminated unsuccessfully
>
> No errors in the alert file and no traces.
> The only file generated is a core file in the cdump dir.
>
> Im restored the database on another server and applied the patchset 9.2.0.7.
> But the error is still there.
>
> I also tried to do a export using transportable tabpespaces. But some
> users have materialized views.
> And when a try drop those views the same error raised up.
>
> I also tried to do a backup with RMAN. But no success.
>
> Any idea?
>
> --
> Gabriel Hanauer
> DBA Oracle
> --
> http://www.freelists.org/webpage/oracle-l
>

Yahoo! Music Unlimited
Access over 1 million songs. Try it free. http://music.yahoo.com/unlimited/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 11 2005 - 15:56:58 CDT