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: doing a transaction that is not logged

Re: doing a transaction that is not logged

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 11 Dec 2002 18:25:18 GMT
Message-ID: <3DF78304.6E159381@exesolutions.com> 





Francis Drai wrote:



> Hello,

>

> AS I have to delete more than 100,000,000 records for a table I would

> like to be able to do this operation without journalization. So I will

> not have pb regarding temporary tablespace. Is it possible. I know that

> this is possible for some other databases.

>

> Thank you




No.



Go with Francis Drai's suggestion.



And in the future look at partitioning.



Dan Morgan
Received on Wed Dec 11 2002 - 12:25:18 CST












Original text of this message













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