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,
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