RE: Export Problem

  • From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • To: <chiragdba@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 5 Oct 2005 09:49:07 -0400

||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

Other related posts: