Is there an easy way to load object sets into the compare. For example I want to compare dev, stage and prod.
I know there are differents between the envs but I also dont care about oracle stuff so I am using the following
select null owner, 'ROLE' object_type, role object_name, null status, null last_ddl_time, null info
select null owner, 'USER' object_type, username object_name, null status, null last_ddl_time, 'Created on: ' || to_char(created) info
and username NOT IN
'XDB', 'SYSTEM', 'SYS', 'LBACSYS',
'DVSYS', 'DVF', 'SYSMAN_RO', 'SYSMAN_BIPLATFORM',
'SYSMAN_MDS', 'SYSMAN_OPSS', 'SYSMAN_STB', 'PUBLIC',
'DBSNMP', 'SYSMAN', 'APEX_040200', 'WMSYS',
'SYSDG', 'SYSBACKUP', 'SPATIAL_WFS_ADMIN_USR',
'SI_INFORMTN_SCHEMA', 'OUTLN', 'ORDSYS', 'ORDDATA',
'OJVMSYS', 'ORACLE_OCM', 'MDSYS', 'ORDPLUGINS',
'GSMADMIN_INTERNAL', 'FLOWS_FILES', 'DIP', 'CTXSYS',
'AUDSYS', 'APPQOSSYS', 'APEX_PUBLIC_USER', 'ANONYMOUS',
'SPATIAL_CSW_ADMIN_USR', 'SYSKM', 'SYSMAN_TYPES',
'MGMT_VIEW', 'EUS_ENGINE_USER', 'GSMCATUSER', 'OLAPSYS',
'CLOUD_SWLIB_USER', 'GSMUSER', 'MDDATA', 'XS$NULL', 'CLOUD_ENGINE_USER' )
order by 1,2,3
but i noticed its only querying the source out the gate and missed roles and users in the target that wasnt in the object set.
I 100% could be doing something wrong, just discovered how useful the object set is.
I did try modifing the DBOS by hand but didnt seem to help because looks like it still filters out via query
Toad for Oracle Xpert (64-bit) (Multiple Keys Active)
Add-Ons: DB Admin Module