Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Datapump expdp throwing - ORA-06502: PL/SQL: numeric or value error

User_KXSF5May 10 2018 — edited Aug 22 2019

Oracle

I was trying to export the set of tables in Oracle 11.2.0.4 database and was getting the following  error.   Searched over the MOS and Web but could not find any solution as this error was previously stated as a bug or some buffer resize issues. 

Data Mining and Real Application Testing options

ORA-06502: PL/SQL: numeric or value error

After reviewing my PARFILE , I noticed that one of the table name is more than 30 character long.  Somehow database allowed that long table name but seems datapump expdp utility still not liking table name of more than 30 character long.  So just resized my table name to a smaller length and it worked like Charm.

Sharing my experience and solution with oracle community

Cheer

Acyuta Priya (DD).

Comments
Post Details
Added on May 10 2018
1 comment
2,797 views