how to know iot overflow tables between two db instances

[kytemaniac]

Code: Select all

select table_name from user_tables where iot_type='IOT_OVERFLOW' minus
select table_name from user_tables@hellasDB4 where iot_type='IOT_OVERFLOW';


Code: Select all

SYS_IOT_OVER_54968
SYS_IOT_OVER_54990


but the result above left me pondering what is the iot tables that is the first db instance but not the second db instance.

[Tim...]

Hi.

Struggling to understand the question.

DB1 MINUS DB2 = Rows in DB1 that are not present in DB2
DB2 MINUS DB1 = Rows in DB2 that are not present in DB1

Does that answer your question?

Cheers

Tim...