Thanks alot to all of you. Thats what I thought

Podo




John Podoletz wrote:
>
> "Ramamurthi, Radha" wrote:
> >
> > 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.
>
> Thanks alot to all of you. Thats what I thought
>
> Podo
>
> >
> > 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] > To subscribe: send a blank email to oracledba-[Email Address Removed] > Visit 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-[Email Address Removed] > To subscribe: send a blank email to oracledba-[Email Address Removed] > Visit 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 documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit 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