dba_streams_transform_function

COLUMN RULE_OWNER HEADING 'Rule Owner'                FORMAT A20
COLUMN RULE_NAME HEADING 'Rule Name'                  FORMAT A20
COLUMN TRANSFORM_FUNCTION_NAME HEAD 'Transform.Function' FORMAT A30

SELECT RULE_OWNER, RULE_NAME, TRANSFORM_FUNCTION_NAME
FROM DBA_STREAMS_TRANSFORM_FUNCTION
/

So far, various static and dynamic views have been presented that help DBAs to understand details about the configuration and also about the run-time statistics. The next step is to address troubleshooting.

Troubleshooting

In this section, some of the useful methods that can be used to handle the error conditions, how to evaluate them and resolve them will be examined.

Capture Related

At times, the Capture process simply stops capturing the database changes. This section will present some scenarios which can affect the Capture process functionality.

Is the Redo File Missing?

Removing required redo log files before they are scanned by a Capture process causes the Capture process to abort and results in the following error in a Capture process trace file: