How do u make SURE a table is empty?????

From: Richard Hollingsworth <RichardH_at_vorlon.hsv.lmsg.lmco.com>
Date: 14 May 1998 21:48:37 GMT
Message-ID: <6jforl$mib1@svlss.lmms.lmco.com>

I have a SQL_LOADER script that tries to read a flat ascii comma-delimited file into an Oracle8 table. As long as I DELETE FROM TABLE1, then use the APPEND option in SQL_LOADER, it works ok. But if I try to use the INSERT option, it errors with "Table must be empty." even though I just did a DELETE FROM TABLE1 first.

Now, the problem with using APPEND is that I don't know how to DELETE FROM TABLE1 inside the SQL_LOADER script, and I don't want a seperate procedure to have to do this.

Any ideas??

Thanx much,

Richard Hollingsworth Received on Thu May 14 1998 - 16:48:37 CDT