Re: PC - sqlload - where is it?

Peter

If your Oracle8 DB Server is located on your PC, then the SQL*Loader (sqlload80) application will be in the ORANT/BIN directory, where all applications and binary files are kept.

If your Oracle8 DB Server is on, for example, a UNIX box, and the PC is in fact an Oracle8 CLIENT, then SQL*Loader (sqlload80) will be in the Oracle Home ORANT/BIN directory on the UNIX server. CHECK WITH ORACLE SUPPORT.

I have used the SQL*Loader (sqlload80) application and written code for SQL*Loader applications using Developer/2000 and Server-side (back-end) PL/SQL. There are various approaches - here are two:

1. Developer/2000 Program Unit on Client PC using a Developer/2000 library procedure called HOST to invoke SQL*Loader (sqlload80) script on the SERVER-side to write data to TEMPORARY / TRANSIENT tables. Then write DATABASE TRIGGERS to read data from TEMPORARY / TRANSIENT tables and write it to your DATABASE tables after data validation, and Delete TRANSIENT tables at end of process.

Note: You could write data DIRECT to Database tables if the data structure is VERY SIMPLE. But if you are writing data to a GROUP of tables with master/detail relations and referential integrity constraints e.g primary key uniqueness and dependencies, and also require data filtering and validation, then you CANNOT write the data direct to Database tables with SQL*Loader as data validation capabilities are very limited. Therefore use DATABASE TRIGGERS for master/detail relations and referential integrity, data filtering and validation etc.

2) Developer/2000 Program Unit on Client PC using a Developer/2000 which then call a bespoke SERVER-SIDE package wtih required procedures and functions etc.. The SERVER-SIDE package calls SQL*Loader (sqlload80) application to write data to TEMPORARY / TRANSIENT tables. Then use SERVER-SIDE package in place of Database Triggers for writing data to your DATABASE tables after data validation, and Delete TRANSIENT tables at end of process.

Hope this helps you. Please contact me soon as Id' be interested to hear your experience.

HTH Joe Moore
Oracle, Business Intelligence and Data Warehousing Specialist Parity Solutions
Email: moorejo_at_it.postoffice.co.uk jmoore_at_parity.co.uk

Peter Hanlon wrote in message <37F73E49.B568D180_at_hanlon.co.uk>...
>If you want a PC loading tool for Oracle checkout
>http://www.hanlon.co.uk.
>
>elbarto99_at_netzero.net wrote:
>
>> I am using Oracle 8.something on a PC
>> at work
>> I wanted to use sqlload but it isn't on
>> the PC
>> Where is it located?
>> How do I install it?
>>
>> I tried to use the Install program and found sqlplus
>> but now sqlload.
>>
>> Any suggestion will be helpfull
>>
>> Thanks in advance
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
Received on Fri Oct 15 1999 - 15:20:58 CEST