The general answer for this question is:
No, you can't turn off the archive mode for a particular table. But in some cases and for very few types of DML operations you can reduce the amount of generated redos by using NOLOGGING option as sugested by fraze.




Reply With Quote