SQl*Loader Can and Can't do

From: Fabian Tiburce <ftiburce_at_frameworks.ca>
Date: Mon, 10 May 1999 12:31:55 -0400
Message-ID: <7h720m$5io$1@goblin.uunet.ca>

Hi group,

In the absence of an FAQ (??), I would like an expert Oracle user to validate the following statements. Your insight is much appreciated.

1 -SQL*Loader can/is installed as part of the client tools. In other words you do not need a copy of the server to use the tool.

2. SQL*Loader cannot run multiple commands in one script. You can't load data from A into table_A then data from B into table_B in the same control file (assuming A and B have different fields of different types).

3. SQL*Loader does not use environment variable. If you need to either APPEND or REPLACE you either need to parse and modify the control file or have a shell script conditionally run one or the other (assuming two control files, one for APPEND, one for REPLACE.)

Please reply to the group and if possible to NOSPAMftiburce_at_frameworks.ca. (remove NOSPAM)

Thanks a lot. Fabien Received on Mon May 10 1999 - 11:31:55 CDT