Hi:

Nologging will generate reduced logging only under certain direct
operations. If your application is not using them, it does not help. I
thought in oracle8i tables such as you describe could be created as
temporary tables within the application. That should reduce the redo
considerably. You should talk to the vendor.

Radha

-----Original Message-----
From: John Podoletz
To: LazyDBA.com Discussion
Sent: 6/28/02 2:06 PM
Subject: selective archiving

Hi,

Is there a way to selectively stop archiving of an apps tables?

We have a purchased an oltp application that has a function, based on
the user's lookup/query, writes large amounts of data into temp
application tables, the data is then manipulated, presented to the user,
and is then deleted.

Correct me if I'm wrong but each time the data is written/committed to
the temp app table and then deleted a redo/archive before/after images
are captured.

I would like to shut off archiving to the temp app tables if possible.

Recovering the temp app tables isn't an issue.

Could I use nologging option on the tables?

Thanks for your time.

Podo

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page