SQL*Loader with dbase files
From: ROUMEGOU ERIC <roumeg_at_infonie.fr>
Date: 1997/11/25
Message-ID: <01bcf9e4$57e02ba0$e0a865c3_at_infonie>#1/1
Date: 1997/11/25
Message-ID: <01bcf9e4$57e02ba0$e0a865c3_at_infonie>#1/1
Hello All...
I'm a new user of Oracle 7.3.2 and my database run on a Novell 4.10 platform with W95 workstations.
I have to load many files from a dbase IV application. So I want to use SQL *Loader and I wrote a program which compose the control(.ctl) file.
I have several problems:
- I can't found a program call DB3PREP which write the control file and a sql script from a dbase file. It's not with Database Manager
- What's the memo fields' description on a control file?
- what's the syntax of "nullif" if I want to replace zero to Null
I sought in Oracle Documentation but it's very poor about this.
An example of a control file with these sorts of cases will be greatly appreciated.
Thanx in advance ...
-- roumeg_at_infonie.frReceived on Tue Nov 25 1997 - 00:00:00 CET