| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLLOADER
On Sat, 01 Mar 1997 02:05:53 GMT, erichansen_at_mindspring.com (Eric Hansen) wrote:
>bmanry_at_upsizeme.us.oracle.com (Bill Manry - Oracle Corporation) wrote:
>
>
>>You can't count on the UNIX version of SQL*Loader to
>>correctly interpret native number data from another
>>platform. This includes binary, float, packed decimal
>>and zoned decimal forms.
>
>Why not? Isn't that it's job? If we can't count on it, should it be
>fixed so we can?
No it is not. Perhaps it would have been better to have said:
You can't count on SQL*Loader to correctly ...... leaving out the unix part.
If you have a 32bit integer on a high-byte to low-byte system and move it to a system that has the opposite byte order, it will be loaded wrong. If you take floating point numbers on one system and move to another system that physically implements floats differently you get them loaded wrong. (actually they'll be loaded right, they will just be interpreted by the OS wrong from your point of view).
This is what SQL*Net is for. If you run sqlldr on the platform with the data, it will get inserted correctly in the target platform over the network, regardless of the data conversions that need to take place.
>
>>Either convert the data to
>>an all-character form or run SQL*Loader on MVS and
>>load to your UNIX DB via SQL*Net.
>>
>>/b
>>--
>>Bill Manry - IBM Products Division - Oracle Corporation
>>These are my opinions, not necessarily Oracle's.
>
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
 |
 |