Re: reducing archive logs generation with nologging option

"Rangesh Kona" <rkona_at_cadence.com> wrote in message news:<3d754d31$1_at_news.cadence.com>...
> Hi,
> My database instance is having three schema's which are named as global,
> local and applic
> Data for global and local is fed from CRM application tables. Any DML
> operation on CRM application tables is mirrored to our tables.
> global and local doesn't require any recovery as these table data is always
> available on CRM side.
> but applic schema tables are critical for us.
> Can we create global and local schema tables with nologging option. Is this
> recommended method of doing it because we need applic schema tables to be
> recovered with in few hours.
> Does Oracle recommends Keeping few tables with nologging option and other
> with logging option.
> please provide me with as much information as you can.
> thanks in advance.
> Rangesh

The nologging operation only applies to certain operations such as create table as select. Normal DML is going to be logged. If the CRM tables are maintained by table triggers and distributed DML then nologging is not going to help. If you are using snapshots/materialized views then nologging might be of value since I see it is an option in the manual.

HTH -- Mark D Powell -- Received on Wed Sep 04 2002 - 08:00:11 CDT