The Mirror Replication Agent pds_username user requires select privileges to the following Oracle system tables:
SYS.OBJ$ – required for processing procedure DDL commands in the repository.
SYS.LOB$ – required for LOB replication support.
SYS.COLLECTION$ – required for VARRAY replication support.
SYS.COL$ – required for table (column info) replication support.
SYS.CON$ – required for table (constraint info) replication support.
The permissions for SYS.CON$ and SYS.CDEF$ are
required to handle the constraint information in the CREATE and
ALTER TABLE DDL operations.
SYS.CDEF$ – required for table (constraint info) replication support.
SYS.USER$ – required for Oracle user identification.
SYS.SEQ$ – required for Sequence objects.
SYS.COLTYPE$ – required for table (column type info).
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.
SYS.PROCEDUREINFO$ – required for procedure replication support.
SYS.ARGUMENT$ – required for procedure (argument info).
SYS.TYPE$ – required for Oracle predefined Type and UDD.
SYS.ATTRIBUTE$ – required for Oracle type (type attribute info).
SYS.CCOL$ – required for table (column constraint info).
