This will not have any effect. see http://www.orafaq.com/wiki/Nologging_and_force_logging
ARS does normal update's, insert's or delete's and this is always logged in the redo-logs. Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Guillaume Rheault Gesendet: Mittwoch, 13. Januar 2010 21:49 An: [email protected] Betreff: Re: Is there a way to set an Oracle nologging option for Remedy Archiving process? You need to find out the schemaid in the arschema table related to your form. Once you do that, you need to issue a sql statement through SQL Plus, Toad or SQL Developer, like this one SQL> alter table T12345 nologging; Guillaume ________________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of Pruitt, Christopher (Bank of America Account) [[email protected]] Sent: Wednesday, January 13, 2010 3:40 PM To: [email protected] Subject: Is there a way to set an Oracle nologging option for Remedy Archiving process? Issue Details: Is there a way to set the nologging option on the Remedy Archive tables when the Remedy archival process is running to disable the Oracle Archiving logging? We need to ensure that it Oracle doesn't generate Oracle archive logs for the Remedy Archiving table when we are pushing data from the data tables to the archive tables. We are having issues where the tablespace growth is directly proportional to the number of records being archived. If there are more records archived, more tablespace growth. In this case since Remedy archiving process would insert on to the Remedy archived tables, the number of Oracle archive logs increase. Last month we ran Remedy Archiving and it generated over 1.5 gb of Oracle Archiving logs in a matter of just a few hours. Environment Remedy version 7.1.00 Build 200708221849 Oracle 10.2.0.4.0 - 64bi OS SunOS 5.9 Christopher Pruitt Business Consulting III HP Enterprises Services [email protected]<mailto:[email protected]> www.hp.com<http://www.hp.com/> Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
