Re: Automatically load data into Table

From: Stephen Murphy <SMurphy1_at_NYCap.RR.Com>
Date: Thu, 23 Nov 2000 00:49:19 GMT
Message-ID: <3A1C6ADF.2DD4079@NYCap.RR.Com>

Use the Truncate clause on the sql*loader control file and it will do the truncate for you before loading the data.

Andrew wrote:
>
> Hi,
> Im using an Oracle 7.3.4 database and I manually perform this task each
> week:
>
> sql> truncate table mytable
> Then I run a batch file "loaddata.bat" that uses sqlLoader.
>
> I wish to fully automate this and have it run via the AT command.
> How can I perform the truncate command via batch,
>
> Thanks In Advance,
> Andrew
Received on Wed Nov 22 2000 - 18:49:19 CST