Import oracle number column default precision

[Christopher Pierce]

I am trying to import an Oracle 9i schema where one of the tables has a column of type NUMBER with no precision specified.

Code: [Select]


create table TEST (
  MY_NUM_COL NUMBER
);


The problem is that when I import this table, the number column in question is always imported with the precision defaulted to 15.

Is there a way to change this default behavior? (i.e., have it default to 38)

I noticed that in "Settings"->"Database Datatypes", you can select "Oracle" as a product, and it has the "default" for NUMBER set to (8,2), but this seems to only work as the default when creating a new table via EA.

Thanks,
Christopher Pierce

[Christopher Pierce]

I noticed that build 800 had the following change log entry:

"Improved import of Oracle NUMBER datatype to distinguish between NUMBER, NUMBER(50), NUMBER(10,2) types."

So I tried downloading the latest build (802) to see if it helped my problem, but it doesn't (NUMBER type still imported with default precision of 15, and I still can't find a way to change this behavior).

Is a there a way to find out the details of the bug that this change log entry fixed?