This content has been marked as final. Show 2 replies
You would had to add the Master_RepObject and and call Generate_Replication_Support between the SUSPEND and RESUME.
The actual creation would be pushed through the DBMS_DEFER_SYS.
Do you have the jobs running in the background ? Have you queried DBA_REPCATALOG to see if the request to create the indexes has been pushed and executed ?
(BTW : I have done this for MultiMaster Replication. Not sure if Indexes on MVs are handled similarly or actually need to be manually created).
Hemant K Chitale
Many thanks for the reply
I have been able to create the indexes at the view site and this is fine for me (the amount of data is small so i dont think there will be a performance hit)
The links were useful thanks