Re: Export fails w/ EXP-00056 & ORA-31600 invalid input value EMIT_SCHEMA

"Mark Bole" <makbo_at_pacbell.net> wrote in message news:UPgoc.66326$k43.42829_at_newssvr25.news.prodigy.com...
> Yves J. wrote:
>
> > Export of this 9i database (9.2.0.3) fails with:
> >
> > EXP-00056: ORACLE error 31600 encountered
> > ORA-31600: invalid input value EMIT_SCHEMA for parameter NAME in
> > function SET_TRANSFORM_PARAM
> > ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
> > ORA-06512: at "SYS.DBMS_METADATA_INT", line 3926
> > ORA-06512: at "SYS.DBMS_METADATA_INT", line 4050
> > ORA-06512: at "SYS.DBMS_METADATA", line 836
> > ORA-06512: at line 1
> > EXP-00000: Export terminated unsuccessfully
> >
> > That function is not in my user schemas.
> >
> > Does it ring a bell to someone?
> >
> > Thanks.
>
> What version of "EXP" are you using?
>
> The general rule is to use the same version of EXP or IMP as the
> database you are connecting to.
>
> What other parameters are you using?
>
> --Mark Bole

Hi Yves,

I have seen this before. The circumstance for me was a newly created 9i Db on Win2k.
It was created with the scripts that DBCA produced. At some point in the install I had a problem with installation of XMLDb. I pressed on and finished the Db, when I tried to export, I got the same message you recieved.

Connect as sys and run the following script @?/rdbms/admin/catmeta.sql . Once this has completed, take an export to confirm that it has worked and I would also take a full backup of the system

HTH Spark Received on Wed May 12 2004 - 03:24:58 CDT