Data compare

Please advise if there is another way to achieve this.

Routinely we compare different schemas with 3000+ data tables. We change the table group we want to compare. Ex:

(a) Compare these 1000 tables from schema A against schema B.
(b) Compare these 500 tables from schema A against schema B.

It is time consuming to select what to compare out of thousands.

Suggestion would be to have an input list to select source tables to compare with target. An example:

select tablename from usertables@A X where exists ( select 1 from inputlist
y where y.tablename = x.table_name and y.category = 'SECURITY' )

In the above sql, only tables from SECURITY category would be compared with B schema.

Several categories would exist on input_list table (security, configuration , master data, users ).

Thanks.