Re: ORA-03113 while exporting

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Tue, 11 Oct 2005 14:32:15 -0700 (PDT)
Message-ID: <20051011213215.91275.qmail@web50113.mail.yahoo.com>

Is there a trace file created when the failure occurs? May be it will have some information. Else, I think it is time to get Oracle Suppor involved.

Good Luck,

• Kirti
  • 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 - 16:34:28 CDT