Re: doing a transaction that is not logged

From: Francis Drai <francis.drai_at_sita.int>
Date: Wed, 11 Dec 2002 18:48:18 GMT
Message-ID: <3DF7874B.35A1C444@sita.int>

Dan,

What do you mean by partionning? If you mean table partition I do not see the relationship with journalization. To my knowledge when I delete some records in a partitioned table I can rollback the transaction so the journalization is effective.

Cheers

Francis

damorgan wrote:
>
> 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:48:18 CST