RE: Oracle 9.2 Export Error
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <rlsmith@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Nov 2005 10:17:24 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Smith, Ron
> Sent: Wednesday, November 16, 2005 9:01 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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.
> --
> //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.
*************************************************************************
--
//www.freelists.org/webpage/oracle-l
Other related posts:
