From oracle-l-bounce@freelists.org Wed Oct 5 08:41:23 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j95DfLu6011758 for ; Wed, 5 Oct 2005 08:41:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j95DfHvX011743 for ; Wed, 5 Oct 2005 08:41:17 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E92E21F34B0; Wed, 5 Oct 2005 08:40:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12069-01; Wed, 5 Oct 2005 08:40:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60E851F339D; Wed, 5 Oct 2005 08:40:32 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=JUsokFqNivBoFuP14LYrcy0xAXl27/bDn1r3kxXwpXm/wjm6svFvs/QKjAO5v8hi2q24TzaOQ79GMb0bhJb9QeJyc1FxTO9IM7YGq2O8Hgzb5IFR9z8F1VjOFyTA+B9clw6L8w79KUbtkO++xwJU40ydACBaPGkmkO7eFxHPCM8= Message-ID: <1a3629600510050638p417d478axbb99d349e6515c78@mail.gmail.com> Date: Wed, 5 Oct 2005 09:38:35 -0400 From: Chirag DBA To: Oracle-L Freelists Subject: Export Problem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18137_8816680.1128519515537" X-archive-position: 26349 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chiragdba@gmail.com Precedence: normal Reply-To: chiragdba@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.1 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_18137_8816680.1128519515537 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 ------=_Part_18137_8816680.1128519515537 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
I am getting this error while exporting. METALNK says that you haverec= ently 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 procedur= al objects and actions
. exporting foreign function library names for us= er SYSADM
. exporting PUBLIC type synonyms
. exporting private type s= ynonyms
. 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 functi= on SET_TRANSFORM_PARAM
ORA-06512: at "SYS.DBMS_SYS_ERROR", lin= e 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-000= 00: Export terminated unsuccessfully
------=_Part_18137_8816680.1128519515537-- -- http://www.freelists.org/webpage/oracle-l