If you now mean 'can I do deletes without generating rollback' then the
answer is most definitely not. You can't switch off rollback generation,
because it's needed by Oracle (and any other users that might, in principle,
be connected) for read-consistency purposes.
Regards
HJR
"Francis Drai" <francis.drai_at_sita.int> wrote in message
news:3DF72689.9CF9EAC1_at_sita.int...
> Sorry I mean rollback segment not temporary tablespace
>
>
> 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
Received on Wed Dec 11 2002 - 12:55:56 CST
