GoldenGate

System Specs:
O/S : RHEL 5 (Tikanga)
RDBMS: 11.2.0.3 (Standalone, ASM, Archivelog)
GoldenGate v:11.1.1.0 (getting ready to upgrade to v11.1.1.2 (want to utilize the ADD SCHEMATRANDATA and updated sequence support)

I have read the documentation in GG that says that DDL support Oracle restricted schemas is not supported (including sys and system). From this document a create statement is considered DDL.

However, I have to think that when a user or role is created on the Source that you want that action replicated to the Targets? So you don't have to rerun the action on the number of targets you have. This is the benefit of replication, correct?

Without this ability replication is somewhat restrictive.

Please someone shed some light on how a user/role statement could be replicated?


Thanks!
Jason