Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Delete without rollback

Re: Delete without rollback

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: Tue, 19 May 1998 16:50:08 GMT
Message-ID: <01bd8346$28e222e0$049a0580@mcb>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US