ALL_STREAMS_NEWLY_SUPPORTED

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

Related View

DBA_STREAMS_NEWLY_SUPPORTED displays information about all tables in the database that are newly supported by Streams capture processes.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

  

Owner of the table

TABLE_NAME

VARCHAR2(128)

  

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)

  

Minimum database compatibility for capture processes to support the database object

See Also:

"DBA_STREAMS_NEWLY_SUPPORTED"