imiport export and precision of number columns

Have any of you done a full export, then full import, and noticed some number column format masks missing?

Just checking, some end users here are complaining that their data has = been
"truncated" but that instead it is now 38-digits long (the default for NUMBER columns).

It hasn't happened to all tables, only a few have reported problems so = far.

I parsed the export file (show=3Dy), and the column definitions show up = as
NUMBER, no number(12,6) for example. Before the reorg I ran Rachel Carmichael's script from PL/SQL Annotated Archives (Oracle Press) to = grab
the table definitions, and the generated script shows those columns as NUMBER(38,0). Also a developer mentioned that some of these tables hold data that was loaded using FoxPro, but I don't think that would have had anything to = do
with this, could it?

(I think Oracle rounds values, it doesn't truncate them. I know I'm = getting
picky.)

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20 Received on Wed Aug 30 2000 - 13:21:51 CDT