Re: SQL Loader questions

Lisa,

No and no. Loader loads rows into tables. If you ask nicely, it will clean out the table completely before it does that. That's all it does. And it does it pretty well.

It does not let users redefine tables.

And it does not do selective update and delete based on the incoming data file. Other loading tools do that (I know DataJunction does, and others) but not Loader.

Yosi

YTTRI Lisa wrote:

> Hi everyone -
>
> I need some help. We have an application running on 8.0.5 on NT. My
> programmer tells me that she should be able to add columns to a table simply
> by changing the sql loader control file definition of the input. I have
> looked through the documentation and tried several tests, but I can't see
> any way that this would work.
>
> Is this actually possible with SQL Loader?
>
> Also, she tells me that if a record exists in the table and she has the same
> record (key value only) in the input file, that SQL Loader should update the
> record with any changed field values. Is there a special keyword to do this
> - I can't seem to find anything on that either?
>
> Thanks in advance for any help you can give me.
>
> Lisa

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yosi Greenfield
  INET: yosi_at_comhill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).