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

Do not use truncate without discussion with your DBA. It may destroy his storage strategy.

Slava.

Peter Schneider <peter.schneider_at_okay.net> wrote in article <355b766e.15399803_at_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 Wed May 20 1998 - 10:27:17 CDT