Re: Redo log question

From: Mirza Mohsin Beg <mbeg_at_netearnings.com>
Date: Tue, 01 Jun 1999 14:03:37 -0700
Message-ID: <37544AA9.38C3424E@netearnings.com>

Create the table/s with the 'nologging' option. Once your loading is done you may 'alter table' to turn loggin back on if you so want.

Nevertheless I would suggest using direct mode SQL*Loader to alleviate the rollback segment problems, something you cannot do with Pro*C.

-M

Venkat wrote:

> Hi,
>
> Is it possible to turn off "redo logging" at table or transaction level? I
> am loading a huge file using a C program into a table, I always truncate the
> table before starting the load. I don't intend to do any rollback and I can
> always reload the data if something happens to the database.
> Any ideas ...
>
> Thanks In Advance.
Received on Tue Jun 01 1999 - 16:03:37 CDT