This command is available only for Oracle and Microsoft SQL Server.
Returns a list of the owners whose objects will be filtered for initialization; adds, removes owners to the list.
To return a list of the owners whose objects will be filtered for initialization:
pdb_ownerfilter
To add or remove an owner whose objects will be filtered for initialization:
pdb_ownerfilter {add | remove}, owner
The add keyword filters out any objects that are owned by the owner you specify. Any objects that are owned by this owner cannot be marked for initialization.
The remove keyword removes the filter for the owner you specify. Any objects that are owned by this owner can be marked for initialization. For Oracle, you cannot remove the “SYS” owner.
The name of the owner that is used for filtering.
The owner option can be delimited with quote characters to specify the character case.
If mixed case (uppercase and lowercase) is required, the name must be delimited. This parameter can be delimited with quotes to specify the character case. If mixed case is required, the name must be delimited. For example:
“Owner”, “oWnEr”
pdb_ownerfilter
This command returns a list of all owners whose objects will be filtered for initialization.
pdb_ownerfilter add, SYSTEM
This command adds the “system” user to the list of owners whose objects will be filtered for replication.
pdb_ownerfilter remove, SYSTEM
This command removes the “system” user from the list of owners whose objects will be filtered for initialization.
pdb_ownerfilter can be used to limit the number of objects that are loaded into the Replication Agent System Database during initialization (see ra_init command). When ra_init is processed, the objects and owners in the pdb_ownerfilter list will not be loaded. You can reduce the size of the RASD and reduce the time to perform initialization by adding owners to the list whose objects are not be replicated, or for owners where the majority of objects are not to be replicated.
Any object marked for replication (using commands pdb_setreptable, pdb_setrepproc), is loaded into the RASD, even if the owner is not on the list. This list affects initialization processing, but not replication (replication occurs based on marking status, not owner filtering).
When pdb_ownerfilter is invoked, its function is determined by the keywords and options you specify.
When multiple keywords and options are specified, each must be separated by a comma. Blank space before or after a comma is optional. For example:
pdb_ownerfilter add, system
When pdb_ownerfilter is invoked with no keyword, it returns a list of users whose objects will be filtered.
The pdb_ownerfilter command is valid only when the Replication Agent instance is in Admin state.
For Oracle, you cannot remove the “SYS” owner.
For Oracle, after initialization you can replicate any object with pdb_setreptable and pdb_setrepproc, except for the following objects which cannot be replicated at any time:
Objects that are owned by “SYS” owner.
Any system table whose name begins with V$.
Any system procedure or package whose name begins with DBMS.