Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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)