Re: Delete command and commit

Roderick Manalac wrote:

> You didn't tell us what version of Oracle you are on. The TRUNCATE
> command is nifty but only available in Oracle7. One way to get around
> it in Oracle V6 was to write something like
>
> delete from foo
> where rownum < 10000;
> commit;
>
> Repeat statements until table is empty. Just creating a new table
> is another option though you would also have to recreate indexes,
> grants, etc.
>
> Hope this helps.
> Roderick

I use Oracle7 and TRUNCATE command is OK. But my manual was old...

 -= Mika =- Received on Thu Dec 14 1995 - 00:00:00 CET