Yes, I am already looking on google and metalink. but generally you need to run catpatch.sql when you upgrade yr DB, I mean apply the patch. but here we havent applied any patch. I run the catalog.sql, but same error for export. so now going to run catpatch.sql. regards - chirag On 10/5/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote: > > ||is it safe to run catpatch.sql ? > > >>"upgraded yr DB and run catpatch.sql." > > ||we hanvent upgraded out DB > > I think you answered you own question. > Safe maybe, maybe not...logical no. > > ||"for parameter NAME in function SET_TRANSFORM_PARAM" > > This seems suspicious...you looked more into this info? > > > Chris Marquez > Oracle DBA > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Chirag DBA > Sent: Wed 10/5/2005 9:38 AM > To: Oracle-L Freelists > Subject: Export Problem > > I am getting this error while exporting. METALNK says that you > haverecently > upgraded yr DB and run catpatch.sql. > we hanvent upgraded out DB, is it safe to run catpatch.sql ? > About to export specified users ... > . exporting pre-schema procedural objects and actions > . exporting foreign function library names for user SYSADM > . exporting PUBLIC type synonyms > . exporting private type synonyms > . exporting object type definitions for user SYSADM > About to export SYSADM's objects ... > . exporting database links > . exporting sequence numbers > . exporting cluster definitions > 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 > > >