SQL Loader - loading from flat files

From: Jan <j_rieper_at_web.de>
Date: 20 Oct 2003 12:28:58 -0700
Message-ID: <ce5b6257.0310201128.681bd677_at_posting.google.com>



hello,

[Quoted] i've got a problem with the sql loader in oracle 8.1.7. i want to load data from a file into an database, but there are difficulties with the datatypes.
the datatype in the database is decimal(15,2) and it fails to load from the file when i either don't specify a datatype in the control file nor if i use decimal or float. it always rejects some fields or loads completly false values.the decimal values in the file are separated with a '.'.do i need to use another datatype in the control file.hope anyone can help me solve this problem...

thanks,
jan Received on Mon Oct 20 2003 - 21:28:58 CEST

Original text of this message