From oracle-l-bounce@freelists.org Wed Oct 5 08:55:41 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j95DtdFs014887 for ; Wed, 5 Oct 2005 08:55:39 -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 j95DtXvX014865 for ; Wed, 5 Oct 2005 08:55:33 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D4E01F2231; Wed, 5 Oct 2005 08:54:48 -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 14726-06; Wed, 5 Oct 2005 08:54:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 53ACF1F2302; Wed, 5 Oct 2005 08:54:47 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5C9B4.0F41470C" Subject: RE: Export Problem Date: Wed, 5 Oct 2005 09:49:07 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Export Problem Thread-Index: AcXJsinPFYQteQ6ETmeokxjLn8VBRgAAWTRC From: "Marquez, Chris" To: , "Oracle-L Freelists" X-archive-position: 26355 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cmarquez@collegeboard.org Precedence: normal Reply-To: cmarquez@collegeboard.org 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.0 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------_=_NextPart_001_01C5C9B4.0F41470C Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ||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@freelists.org on behalf of Chirag DBA Sent: Wed 10/5/2005 9:38 AM To: Oracle-L Freelists Subject: Export Problem =20 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 ------_=_NextPart_001_01C5C9B4.0F41470C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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@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

------_=_NextPart_001_01C5C9B4.0F41470C-- -- http://www.freelists.org/webpage/oracle-l