2 Replies Latest reply: Nov 23, 2012 10:47 AM by ScoobySi RSS

    Number & Numeric data types


      My table contains data, its a very big size table, few columns data type is just Number ( no precession or scale declared). When this table get imported into OWB and used in the mappings then the size of the number columns is showing as Numeric with zero as precision and scale. The source table in the mapping contains same data type columns but with precision and scale declared. When I validating the mapping I am getting 'Column precision is greater then the target column' error.

      I tried to alter the table with the same precision and scale as source but as data is already existing , oracle throws can not reduce the size. I don't want to create an other table and dump the data and reload as this is a big table.

      Is there any solution for this issue, please help.