Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: doing a transaction that is not logged
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