Database Software

Hi Experts,

i run sql mbased on document as
SQL> COLUMN OWNER HEADING 'Object|Owner' FORMAT A8
SQL> COLUMN TABLE_NAME HEADING 'Object Name' FORMAT A30
SQL> COLUMN REASON HEADING 'Reason' FORMAT A30
SQL> COLUMN AUTO_FILTERED HEADING 'Auto|Filtered?' FORMAT A9
SQL>
SQL> SELECT OWNER, TABLE_NAME, REASON, AUTO_FILTERED FROM DBA_STREAMS_UNSUPPORTED;

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
ABSOL MLOG$_VMS_ALC_IO_STATUS materialized view log YES
EXFSYS EXF$DEFIDXPARAM column with user-defined type NO
EXFSYS EXF$ESETIDXPARAM column with user-defined type NO
EXFSYS EXF$PREDATTRMAP column with user-defined type NO
EXFSYS RLM$EQUALSPEC column with user-defined type NO
EXFSYS RLM$INCRRRSCHACT column with user-defined type NO
EXFSYS RLM$SCHACTLIST column with user-defined type NO
MDSYS SDO_COORD_OP_PARAM_VALS column with user-defined type NO
MDSYS SDO_COORD_REF_SYS column with user-defined type NO
MDSYS SDO_CS_SRS column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
MDSYS SDO_GEOM_METADATA_TABLE column with user-defined type NO
MDSYS SDO_GEOR_SYSDATA_TABLE column with user-defined type NO
MDSYS SDO_INDEX_METADATA_TABLE column with user-defined type NO
MDSYS SDO_STYLES_TABLE column with user-defined type NO
MDSYS SDO_TOPO_METADATA_TABLE column with user-defined type NO
STRMADMI AQ$_STREAMS_QTABLE_APPLY_C AQ queue table NO
N

STRMADMI AQ$_STREAMS_QTABLE_APPLY_D column with user-defined type NO
N

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------

STRMADMI AQ$_STREAMS_QTABLE_APPLY_G column with user-defined type NO
N

STRMADMI AQ$_STREAMS_QTABLE_APPLY_H unsupported column exists NO
N

STRMADMI AQ$_STREAMS_QTABLE_APPLY_I unsupported column exists NO
N


Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
STRMADMI AQ$_STREAMS_QTABLE_APPLY_P column with user-defined type NO
N

STRMADMI AQ$_STREAMS_QTABLE_APPLY_S AQ queue table NO
N

STRMADMI AQ$_STREAMS_QTABLE_APPLY_T AQ queue table NO
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_C AQ queue table NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_D column with user-defined type NO
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_G column with user-defined type NO
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_H unsupported column exists NO
N

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_I unsupported column exists NO
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_P column with user-defined type NO
N

STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_S AQ queue table NO
N


Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
STRMADMI AQ$_STREAMS_QTABLE_CAPTURE_T AQ queue table NO
N

STRMADMI STREAMS_QTABLE_APPLY column with user-defined type NO
N

STRMADMI STREAMS_QTABLE_CAPTURE column with user-defined type NO
N

SYSMAN AQ$_MGMT_NOTIFY_QTABLE_G column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_H unsupported column exists NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_I unsupported column exists NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_S AQ queue table NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_T AQ queue table NO
SYSMAN MGMT_BLACKOUT_SCHEDULE column with user-defined type NO
SYSMAN MGMT_DELTA_COMP_SUMMARIES column with user-defined type NO
SYSMAN MGMT_DELTA_SUMMARY_ERRORS column with user-defined type NO
SYSMAN MGMT_JOB_CRED_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_PARAMETER column with user-defined type NO
SYSMAN MGMT_JOB_PARAM_SOURCE column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
SYSMAN MGMT_JOB_PROP_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_SCHEDULE column with user-defined type NO
SYSMAN MGMT_JOB_SEC_INFO column with user-defined type NO
SYSMAN MGMT_JOB_SQL_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_STEP_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_SUBST_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_USER_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_VALUE_PARAMS column with user-defined type NO
SYSMAN MGMT_NOTIFY_QTABLE column with user-defined type NO
SYSMAN PARAM_VALUES_TAB column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_G column with user-defined type NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_H unsupported column exists NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_I unsupported column exists NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_S AQ queue table NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_T AQ queue table NO
WMSYS WM$EVENT_AUX_PARAMS_NT column with user-defined type NO
WMSYS WM$EVENT_QUEUE_TABLE column with user-defined type NO
WMSYS WM$VERSIONED_TABLES column with user-defined type NO
WMSYS WM$VERSIONED_TABLES_UNDO_CODE column with user-defined type NO
XDB XDB$ALL_MODEL column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
XDB XDB$ANY column with user-defined type NO
XDB XDB$ANYATTR column with user-defined type NO
XDB XDB$ATTRGROUP_DEF column with user-defined type NO
XDB XDB$ATTRGROUP_REF column with user-defined type NO
XDB XDB$ATTRIBUTE column with user-defined type NO
XDB XDB$CHOICE_MODEL column with user-defined type NO
XDB XDB$COLUMN_INFO column with user-defined type NO
XDB XDB$COMPLEX_TYPE column with user-defined type NO
XDB XDB$ELEMENT column with user-defined type NO
XDB XDB$GROUP_DEF column with user-defined type NO

Object Auto
Owner Object Name Reason Filtered?
-------- ------------------------------ ------------------------------ ---------
XDB XDB$GROUP_REF column with user-defined type NO
XDB XDB$H_LINK column with user-defined type NO
XDB XDB$NLOCKS column with user-defined type NO
XDB XDB$RESOURCE column with user-defined type NO
XDB XDB$ROOT_INFO unsupported column exists NO
XDB XDB$SCHEMA column with user-defined type NO
XDB XDB$SEQUENCE_MODEL column with user-defined type NO
XDB XDB$SIMPLE_TYPE column with user-defined type NO

82 rows selected.

SQL>
DOc state as:
(http://download.oracle.com/docs/cd/B28359_01/server.111/b28321/strms_otmon.htm#i1020290)
Because the Auto Filtered? column is NO for other database objects listed in the example output, capture processes do not filter out changes to these database objects automatically. If a capture process attempts to process changes to these unsupported database objects, then the capture process raises an error. However, you can avoid these errors by configuring rules sets that instruct the capture process not to capture changes to these unsupported objects

We get lots of apply error in bi-direction stream in Oracle10GR2 in 32 bit window.

I need to example code for this case.

Thanks,
Jim