Re: EXP-00008 ORA-03113 EXP-00000

FreeDBA wrote:
> Hi, i have a probleme during exportinf full database :
>
>
> . exporting referential integrity constraints
> . exporting synonyms
> EXP-00008: ORACLE error 3113 encountered
> ORA-03113: end-of-file on communication channel
> EXP-00000: Export terminated unsuccessfully
> ~
>
> if someone could help me ? thank's

You likely have a messed up view. Try writing a quickie program to compile all views and see what blows up. Also check alert log for any other errors.

set pages 0
set feed off
set verify off
spool simple_compile.sql
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects where object_type = 'VIEW'; spool off
@simple_compile
spool still_bad.sql
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects where status = 'INVALID'; spool off
!more still_bad.sql

jg

--
@home.com is bogus.  "The fans were outraged he was here.  Who was
Trevor Hoffman? Who was this pitcher their team had got in a trade for
a Triple Crown (-caliber) hitter Gary Sheffield? There were some very
mad people in San Diego. We were afraid to say Trevor played for the
Padres...  We decided to tell people Trevor was a cookie maker." -
Tracy Hoffman