Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> re: Delete without rollback
Use the TRUNCATE statement.
> -----Original Message-----
> From: x [SMTP:x_at_x.com]
> Posted At: Saturday, May 16, 1998 6:54 PM
> Posted To: server
> Conversation: Delete without rollback
> Subject: Delete without rollback
>
> 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 - 08:02:58 CDT