how to find different objects to different other database used by database link


select index_name as "ANARDB indexes" from dba_indexes where owner like 'OC_%'
 minus
 select index_name from dba_indexes@ANARDB1 where owner like 'OC_%';
 
select sequence_name as "ANARDB sequences" from dba_sequences where sequence_owner like 'OC_%'
 minus
 select sequence_name from dba_sequences@ANARDB1 where sequence_owner like 'OC_%'
 
select table_name "ANARDB tables" from dba_tables where owner like 'OC_%'
minus
select table_name from dba_tables@ANARDB1 where owner like 'OC_%';




select index_name as "ANARDB indexes" from dba_indexes where owner like 'OC_%'
 minus
 select index_name from dba_indexes@ANARDB1 where owner like 'OC_%';
 
select sequence_name as "ANARDB sequences" from dba_sequences where sequence_owner like 'OC_%'
 minus
 select sequence_name from dba_sequences@ANARDB1 where sequence_owner like 'OC_%'
 
select table_name "ANARDB tables" from dba_tables where owner like 'OC_%'
minus
select table_name from dba_tables@ANARDB1 where owner like 'OC_%';
select procedure_name as "ANARDB procedures" from dba_procedures where owner like 'OC_%'
 minus
 select procedure_name from dba_procedures@ANARDB1 where owner like 'OC_%';
 
select object_name as "ANARDB functions" from dba_objects where object_type='FUNCTION' and owner like 'OC_%'
 minus
 select object_name from dba_objects@ANARDB1 where object_type='FUNCTION' and owner like 'OC_%';
 
select view_name as "ANARDB views" from dba_views where owner like 'OC_%' 
 minus
 select view_name from dba_views@ANARDB1 where owner like 'OC_%';
 
select synonym_name as "ANARDB synonyms" from dba_synonyms where owner like 'OC_%'
 minus
 select synonym_name from dba_synonyms@ANARDB1 where owner like 'OC_%';
 
select object_name as "AZKKAUT triggers" from dba_objects where object_type='TRIGGER' and owner like 'OC_%'
 minus
 select object_name from dba_objects@ANARDB1 where object_type='TRIGGER' and owner like 'OC_%';
 
select column_name as "ANARDB columns" from dba_tab_columns where owner like 'OC_%'
 minus
 select column_name from dba_tab_columns@ANARDB1 where owner like 'OC_%';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: