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. 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 replication.
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.
