RE: Export Problem

||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_at_freelists.org 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

--
http://www.freelists.org/webpage/oracle-l