ALL_STREAMS_NEWLY_SUPPORTED

ALL_STREAMS_NEWLY_SUPPORTED displays information about the tables accessible to the current user that are newly supported by Streams.

Related View

DBA_NEWLY_SUPPORTED displays information about all tables in the database that are newly supported by Streams.

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 was not supported in a previous release:

  • 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
COMPATIBLE CHAR(4)   Latest COMPATIBLE setting when the table was unsupported

See Also:

"DBA_STREAMS_NEWLY_SUPPORTED"