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: