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_at_collegeboard.org> 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_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
Received on Wed Oct 05 2005 - 09:01:51 CDT
