Re - define Database datatypes

[rabra]

Hallo,

I work with an Oracle Database and EA. Many (perhaps all) Oracle - Datataypes are defined in EA.
Do I have the possibility of re - defining these datatypes?
E.g. if I want to have for NUMBER a default of 9,0 instead of the predefined 8,2.

Does anybody know a way?

(And besides: Is there a possibility to change the tab behaviour? It would be nice to select the datatype -> tab to precision, then scale. Instead precision is skipped...)

Thanx
Rabra

[Dave_Bullet]

I see the UI has the precision and scale greyed out and these cannot be changed.  I think these fields are only enabled on new types

However, datatypes are stored in the t_datatypes table.  This will make the change you want:

update t_datatypes
set defaultprec = 9
where defaultprec = 8 and productname = 'Oracle' and datatype ='NUMBER'

Cheers,
David.