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: deleting large number of records from table...

Re: deleting large number of records from table...

From: Heber Ferraz-Leite <hferraz_at_via.at>
Date: 1997/11/16
Message-ID: <346da5df.2316290@news.via.at>#1/1 







On 14 Nov 97 10:27:37 GMT, "Sea Fox" <wieslawg_at_comarch.pl> wrote:



>

>You can use truncate command. It does not use rollback segment.

>




Sorry, but a truncate is not a delete.  If you truncate you lose all
data in the table.  If you delete you can select which are gone and
which stay.




Heber

---
hferraz_at_via.at


Received on Sun Nov 16 1997 - 00:00:00 CST












Original text of this message













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