Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Automatically load data into Table

Automatically load data into Table

From: Andrew <apomphre_at_sewl.com.au>
Date: Thu, 23 Nov 2000 10:36:07 +1100
Message-ID: <jLYS5.42041$SF5.754792@ozemail.com.au> 






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 - 17:36:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US