> Its like the "audit" facility on a system I've recently seen. > ins/upd/del on every single table - > every single row change logged to a single audit table which (in > order to handle all tables) has > columns (renamed to preserve anonymity) > > id number (surrogate key) > dt date (timestamp) ... > > So now there's several hundred million records in there...Also a bit > of bummer that pretty much > any kind of analysis query simply never comes back within reasonable > time frames (if it all...). > > Thus its data stored that will never be read :-) > Connor, we all know what a jokester you are. You're making this up, right? ;-) Jared ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------