1 Reply Latest reply on Aug 22, 2019 12:45 PM by 58d3b8f3-7998-4ce4-85c2-6289bd27f7c3

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

    2677109

      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).