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 christopher.pru...@hp.com<mailto:mary.jo...@hp.com> 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
<<attachment: Picture (Device Independent Bitmap) 1.jpg>>