Remember in JDE auditing, the following is used:
The base table (say F0911) is converted to a view of the same name.
The data from the base table is copied to a table called F0911_ADT. (insert into select * from)
Triggers are installed on the F9011_ADT to write audit records to the A0911.
All of the existing indexes are built against the ADT table - but they are all rebuilt!!! This takes a long time for a big table.
Subscribe to:
Post Comments (Atom)
-
Why am I still doing this. Fixing fat clients is not a lot of fun. Here is a couple of tips for connecting to the database using NTS and... -
Ever wanted to know what that pesky OMW transfer error message code meant, here is the list of errors and what they mean in some meaningful...
-
CK : User Preference Cookies (what is saved in user preferences – Enable Hover Forms etc) GF : Grid Format (added when user adds a fri...
No comments:
Post a Comment