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: 1. Using an earlier version of exp to do this on 9.2.0.6. 2. The database is somehow crashing or restarting when this happens.
--Tom
--- Gabriel Hanauer <gabriel.hanauer@(protected)> 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 (See ORA-03113.ora-code.com): 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
