ALL_SOURCE_TABLES describes the existing source tables accessible to the current user. This view is intended for use by Change Data Capture subscribers.
DBA_SOURCE_TABLES describes all existing source tables in the database.
USER_SOURCE_TABLES describes the existing source tables owned by the current user.
| 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: