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 ? It it possible ?

Re: Delete without rollback ? It it possible ?

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 6 Aug 1998 05:52:35 GMT
Message-ID: <6qbgb3$nio$1@news00.btx.dtag.de>


Hi,

to delete ALL rows from your table use the TRUNCATE-command.

John Finn schrieb:
>
> Is it possible to delete multiple rows from a table without rollback
> segment overhead, and without possibility for rollback?
>
> Thanks
>
> jfinn

--

Regards

Matthias Gresz :-)

--
Matthias.Gresz_at_Privat.Post.DE

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\


Received on Thu Aug 06 1998 - 00:52:35 CDT

Original text of this message

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