Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without rollback
The command you want is called 'truncate' You must be the owner or have
'delete any table' privilege.
x <x_at_x.com> wrote in article <355E1903.28A0_at_worldnet.att.com>...
> Could some on please help me with.
>
> I need to delete 100000 rows from a very large
> table in a SQL*Plus session.
>
> Is there a way to disable the rollback feature so
> that the delete will be faster.
>
> I am looking for something similar to UNRECOVERABLE in
>
> "create table test1 UNRECOVERABLE as
> select * from test"
>
> Thanks
>
Received on Tue May 19 1998 - 13:28:22 CDT