Expert Answer Center > Experts On Demand > View Answer
EMAIL THIS
Experts on Demand
  EXPERTS ON DEMAND HOME     POSE A QUESTION     VIEW ANSWERS     BROWSE BY TOPIC        RSS FEEDS  
I don't need any "undo" functionality on a database. Can I set the "undo retention" to 0? Will that have any bad effects? QUESTION POSED ON: 19 JAN 2006
QUESTION ANSWERED BY: Paul Baumgartel Every Oracle database requires undo functionality. It is an essential part of Oracle's read consistency mechanism; it makes rollback possible and you cannot disable it. If you don't intend to use flashback, just leave the undo_retention parameter at its default value.
HomeExperts on DemandIT Expert Webcast SeriesExpert KnowledgebaseSite Index
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts