Re: doing a transaction that is not logged

He means that if you've partitioned your table, it is likely that you can do some partition DDL to get rid of the rows, rather than DML. That is, you can 'drop partition X' instead of 'delete from table where...'.

DDL doesn't generate rollback.

(Well, OK... it generates some small quantity of rollback for the updates to the data dictionary that result from the DDL statement, but that's utterly trivial in size compared with what a delete of 100M rows would produce).

Regards
HJR "Francis Drai" <francis.drai_at_sita.int> wrote in message news:3DF7874B.35A1C444_at_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 - 13:04:29 CST