DBA_SOURCE_TABLES describes all source tables in the database for which a change table is defined. This view is intended for use by Change Data Capture publishers.
USER_SOURCE_TABLES describes the source tables owned by the current user for which a change table is defined.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SOURCE_SCHEMA_NAME |
VARCHAR2(30) |
NOT NULL |
Table owner in the source database |
SOURCE_TABLE_NAME |
VARCHAR2(30) |
NOT NULL |
Table name in the source database |
See Also:
"USER_SOURCE_TABLES"