The select privileges for the following Oracle system tables in the primary database server must be granted to the Replication Agent pds_user_name/user:
SYS.TAB$ – required to support table replication
SYS.MLOG$ – required to filter out materialized view log tables
SYS.TABPART$ – required to support partitioned table replication
SYS.TABCOMPART$ – required to support partitioned table replication
SYS.TABSUBPART$ – required to support partitioned table replication
SYS.NTAB$ – required to support table replication
SYS.IND$ – required to identify indexes
SYS.INDPART$ – required to identify indexes
SYS.INDCOMPART$ – required to identify indexes
SYS.INDSUBPART$ – required to identify indexes
SYS.LOBCOMPPART$ – required to support partitioned LOB replication
SYS.LOBFRAG$ – required to support partitioned LOB replication
SYS.TS$ – required to identify tablespace encryption in Oracle 11g
SYS.SNAP$ – required to filter out materialized view tables