Re: How to disable transactions

NOLOGGING / LOGGING is functionally identical to UNRECOVERABLE - its just that Oracle are gradually going to de-emphasise and de-support the latter. (says so in the documentaion!)

amrane wrote:

> Use the unrecoverable option of the create table/index.
>
> Thanks,
>
> Iks wrote in message <7vu4rj$an6$1_at_sunsite.icm.edu.pl>...
> >Hello,
> >
> >I am working with Oracle 8.0.5 (Solaris). My database is cyclically
> >removed and loaded again from other system, just for analysis only,
> >and I don't need sophisticated techniques like transaction processing
> >because most important issue for me is the performance.
> >Very ofthen I have to do : create table ... as select ..... then I have to
> >update
> >some fields. I would like to disable transaction processing, but I don't
> >know
> >how to do it.
> >Is there anybody who can help me ?
> >
> >
> >Regards,
> >Iks
> >
> >
Received on Wed Nov 10 1999 - 16:15:35 CST