Re: Export Problem

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • Date: Wed, 5 Oct 2005 09:58:02 -0400

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

Other related posts: