ALL_STREAMS_UNSUPPORTED

ALL_STREAMS_UNSUPPORTED displays information about the tables accessible to the current user that are not supported by Streams in this release of the Oracle Database.

Related View

DBA_STREAMS_UNSUPPORTED displays information about all tables in the database that are not supported by Streams in this release of the Oracle Database.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the table
TABLE_NAME	VARCHAR2(30)		Name of the table
REASON	VARCHAR2(39)		Reason why the table is not supported: IOT column with user-defined type unsupported column exists object table AQ queue table temporary table sub object external table materialized view FILE column exists materialized view log materalized view container table streams unsupported object domain index IOT with overflow IOT with LOB IOT with physical Rowid mapping mapping table for physical rowid of IOT IOT with LOB IOT with row movement summary container table
AUTO_FILTERED	VARCHAR2(3)		Indicates whether Streams automatically filters out the object (YES) or not (NO)

See Also: "DBA_STREAMS_UNSUPPORTED"