SQl*Loader Can and Can't do
Date: Mon, 10 May 1999 12:31:55 -0400
Message-ID: <7h720m$5io$1_at_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 - 18:31:55 CEST