DBA_LOGSTDBY_NOT_UNIQUE
displays all tables that have no primary and no non-null unique indexes. Most of the tables displayed by this view are supported because their columns contain enough information to be maintained in a logical standby database. Some tables, however, cannot be supported because their columns do not contain the necessary information. Unsupported tables usually contain a column defined using an unsupported data type.
In a CDB, the data displayed pertains to the container in which the view is queried.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Schema name of the non-unique table |
|
|
|
Table name of the non-unique table |
|
|
|
|