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

  • materialized 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"