ALL_CAPTURE_PARAMETERS

2.69 ALL_CAPTURE_PARAMETERS

ALL_CAPTURE_PARAMETERS displays information about the parameters for the capture processes that enqueue the captured changes into queues accessible to the current user.

Related View

DBA_CAPTURE_PARAMETERS displays information about the parameters for all capture processes in the database.

Column	Datatype	NULL	Description
`CAPTURE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the capture process
`PARAMETER`	`VARCHAR2(128)`	`NOT NULL`	Name of the parameter
`VALUE`	`VARCHAR2(4000)`		Parameter value
`SET_BY_USER`	`VARCHAR2(3)`		Indicates whether the parameter value was set by the user (`YES`) or was not set by the user (`NO`). If `NO`, then the parameter is set to its default value. If `YES`, then the parameter may or may not be set to its default value.
`SOURCE_DATABASE`	`VARCHAR2(128)`		Global name of the container for which the capture parameter is defined