Mark W. Farnham apparently said,on my timestamp of 13/08/2004 11:36 PM: > life. I'm not sure whether my knowledge of them is still subject to > non-disclosure, so I won't quote the standards (which date from at least > 1987) here. Where I work there are two schools of thought on this. One says "exactly the same as e-Business suite". Another says "last changed by, timestamp and row status flag". I like this second one: simple and just about covers everything. > archiving, which you could require as part of the audit requirements. well nowadays a prod system should really be using archiving. No matter what. I know a few that aren't but they are in older Oracle versions and are really small dbs that can have a daily export done in no time at all. Yet: it is a requirement. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ---------------------------------------------------------------- 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 -----------------------------------------------------------------