Need help for sqlloader

[DavidGe]

I met a problem when I use sql*loader to load data into an oracle 9i database.

The data to be load have a column with the type number(20,2). In the data file, the column has datas like 00.00 .
When I use sql-loader to load the file, it report error message: invalid number.

But if I load it to another oracle 9i database on another computer, it works out.

Is it the problem of the oracel 9i client? How to fix it?

Please give me some idea about this issue, thanks a lot in advance.

David

 

[alexhu]

This is a bit vague

Show us the loader script and the table definitions of both working and non-working tables

Alex