This content has been marked as final. Show 1 reply
The name of this forum is "Streams."
I see nothing in your posting that tells me what type of replication you are doing.
What version you are doing it in ... 11gR2 could be three different versions.
Your definition of "huge"
What technology you are using to create the indexes ... for example are you using DBMS_INDEX_UTL?
Whether your "huge" tables are indexed?
etc. etc. etc.
Not even why you are creating all these indexes and how you have verified the need for them.
So no help is possible at this time.