I was trying to export the set of tables in Oracle 184.108.40.206 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
Acyuta Priya (DD).
Thank you for your solution, it's really helpful!