Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without rollback
You can ue the truncate command - it empties the table without using
rollback space:
truncate table table_name;
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
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 - 11:50:08 CDT