2 Replies Latest reply: Jul 10, 2013 11:09 AM by Hussein Sawwan-Oracle RSS

    OATM Issue in resizedb.sql

    Shaik

      Hi

       

      We are in the process of upgrade from 11.5.9 CU2 to R12.1

       

      here I have struked in  OATM Post Migration step:


              Run Post Migration Steps


      1. Run audit report
      2. Enable constraints/triggers/policies & start queues
      3. Resize old tablespaces


      Note: Please complete refresh all the Materialized Views
            in Oracle Applications before using the system.

      [Q]uit        [B]ack

      Please enter your option -
      Invalid Option.
      Please enter your option -  3


      Resizing the datafiles of old tablespaces. This may take a while. Please wait...


      Error generating datafile resizing script /data/apps/testappl/fnd/11.5.0/bin/resizdb.sql

      Press Return key to continue...

       

      I have checked the resized.sql it is showing as:

       

      spool resizdb.log

      declare

      *

      ERROR at line 1:

      ORA-01426: numeric overflow

      ORA-06512: at line 40

       

      Please suggest to resolve the issue.

       

      Thanks

      Shaik