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

From: Peter Schneider <peter.schneider_at_okay.net>
Date: Thu, 14 May 1998 22:57:59 GMT
Message-ID: <355b766e.15399803@news.okay.net>

On 14 May 1998 21:48:37 GMT, RichardH_at_vorlon.hsv.lmsg.lmco.com (Richard Hollingsworth) wrote:

>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??

Hi Richard,

use the loader TRUNCATE option. If the user who performs the load is not the table owner, he well need the 'drop any table' system privilege however, which may be a security hazard.

HTH
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Thu May 14 1998 - 17:57:59 CDT