Re: newbie help please - SQL Plus DELETE

Truncate should and does work.

Here's the syntax

TRUNCATE TABLE SIR_TRACKING; If you want to clear out a whole table, this is the fastest way to go, since no logging occurs.

If you were to say :

DELETE FROM SIR_TRACKING; The end result would be the same, with the exception that it will take a long time (assuming a large table) since every row will be logged.

On the other hand :

DROP TABLE SIR_TRACKING; will kill the table.

Jeffrey T. Kempiners wrote in message
<01bd5f2d$f21b89e0$f748020a_at_Jeffrey_.ace.ac.com>...
>Hello all,
> I'm attempting to delete all of the records from a table, effectively
>clearing the contents of this table. This is a statistics table that we
>clear out once a week.
> I'm developing the application using Personal Oracle Lite 7 as the dev
>environment, until we get the server up and running with oracle for
>workgroups 7.3.
> I have attempted virtually every documented SQL command I can find, from
>truncate to drop to delete, and nothing will work. This table is quite
>large by the time we're looking to clear it. If anybody knows the syntax
>I'd use from an sql plus prompt to delete all the records while leaving the
>table data and columns in place, i'd greatly appreciate it.
>
>
>second (and much more brief) question:
> When I type the following:
>SELECT * FROM SIR_TRACKING;
> I get the following error message:
>buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.
> I've then issued the command
>SET ARRAYSIZE 5000;
>SET MAXDATA 60000;
> and try it again, still no luck. Any ideas what I'm doing wrong?
>
>Thanks very much,
>-Jeffrey T. Kempiners
Received on Fri Apr 03 1998 - 00:00:00 CST