alch
Active Member
Hi,
Does anybody have several active audited pathcodes/environments? Oracle support says that only one pathcode/environment can be actively audited. According to Oracle having two simultaneously audited environments can cause data corruption. I am a bit confused with this explanation as the auditing is done by database triggers; how triggers in different libraries/schemas can interfere with each other? At least you should not have any issues if your PD and PY tables are on different DB/logic servers.
I thought about creating new SystemPY datasource having its own F95XXXX tables on a different non-PD database server.
Does anybody have several active audited pathcodes/environments? What was your approach?
Thanks.
Alch
Does anybody have several active audited pathcodes/environments? Oracle support says that only one pathcode/environment can be actively audited. According to Oracle having two simultaneously audited environments can cause data corruption. I am a bit confused with this explanation as the auditing is done by database triggers; how triggers in different libraries/schemas can interfere with each other? At least you should not have any issues if your PD and PY tables are on different DB/logic servers.
I thought about creating new SystemPY datasource having its own F95XXXX tables on a different non-PD database server.
Does anybody have several active audited pathcodes/environments? What was your approach?
Thanks.
Alch