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)
-
There are a heap of instructions of what you need to change if you change the IP address of your weblogic server, but I find they are not co...
-
I need to support long usernames for a 8.98.1.1 site via MAD LDAP. I’m thinking that I can get the collaborative portal to do the full leng...
-
If you want to change this, there is a lot of BS on the internet, something like – change the startup parameters and add this… XX:MaxPermSi...
No comments:
Post a Comment