Number Type from Oracle to Teradata

I need to replicate some tables of Oracle in Teradata.
I have a script that create the sql for the Teradata’s table, so far everything worked fine but I have a small problem.

I look the information for the columns type in the table “all_tab_columns”, but I have find that some NUMBER columns have data_precision and data_scale as NULL. So I can’t replicate them in Teradata because the NUMBER type demands precision and scale, both greater than 0.

Has anyone worked with this or can give me an idea?

Thanks!

Answer

You can define number or number(*) in Teradata, too.
Simply try it.