RE: Oracle 9.2 Export Error

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Wed, 16 Nov 2005 10:17:24 -0600
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E360120E52D@CWYMSX04.Corp.Acxiom.net>

This may not directly apply, but I started getting the same error after upgrading from 9.2.0.4 to 9.2.0.6, when setting a VARCHAR2(4000) variable to output from DBMS_METADATA.GET_DDL ... I changed the statement to do a SUBSTR(...1,4000) and that resolved it.

You obviously can't do the same with an exp, but what about setting other exp-related parameters to 4000 or less, such as recordlength? Still a bug, but it might help you get your exp done.

Dave

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Smith, Ron
> Sent: Wednesday, November 16, 2005 9:01 AM
> To: oracle-l_at_freelists.org
> Subject: Oracle 9.2 Export Error
>
> I am trying to do an export of a new 9.2.0.7 database on a Sun server.
>
> I am getting this error:
>
> EXP-00056: ORACLE error 6502 encountered
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at "SYS.DBMS_METADATA", line 519
> ORA-06512: at "SYS.DBMS_METADATA", line 663
> ORA-06512: at line 1
> EXP-00056: ORACLE error 6502 encountered
> ORA-06502: PL/SQL: numeric or value error: character string buffer too
> small
> ORA-06512: at "SYS.DBMS_METADATA", line 519
> ORA-06512: at "SYS.DBMS_METADATA", line 663
> ORA-06512: at line 1
> EXP-00000: Export terminated unsuccessfully
>
>
> Patch 3361288 says it fixes it in 9.2.0.5 and 9.2.0.6.
>
>
> Any ideas?
> Thanks!
> Ron
>
>
> Important Notice!!
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited.
> Please let me know immediately by return e-mail if you have received
this
> message by mistake, then delete the e-mail message.
> Thank you.
> --
> http://www.freelists.org/webpage/oracle-l

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 16 2005 - 15:19:10 CST