Re: sqlldr Question

http://technet.oracle.com/doc/oracle8i_816/server.816/a76955/ch05.htm#1892

You will want to either use the TRUNCATE or REPLACE methods (likely you'll achieve better performance with TRUNCATE). However, if there are changes made to your table from an outside source (eg. forms, or from sql*plus), then those changes will be lost unless those changes are also in the file that you are using to load the data from.

Sunil wrote:
>
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3CEA7FFF.86D071AA_at_exesolutions.com...
> > Sunil wrote:
> >
> > > I need to load some data into a table from a file.
> > > Later The file may undergo some changes and these changes will have to
> be
> > > reflected in the table. There is a pk column in the table (name) .
> > > How can I go about this.
> > >
> > > Thanks,
> > > Sunil.
> >
> > How is this a SQL loader question?
> >
> > In fact ... I don't see a single question mark in your entire post.
> My english Grammer ( or is it punctations ) are not so good, Sorry
> !.
>
> > I guess, to be helpful, I'll refer you back to the 'Subject' of your
> posting:
> > Use SQL Loader.
> I had gone through doc. I see the append and truncate options but am
> confused as I will not be able to use both.
>
> > If you are trying to find out how to use SQL Loader go to
> > http://technet.oracle.com or http://tahiti.oracle.com.
> >
> > Daniel Morgan
> >
Received on Tue May 21 2002 - 13:23:22 CDT