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


select index_name as "AZKKUAT indexes" from dba_indexes where owner like 'OC_%'
 minus
 select index_name from dba_indexes@azkkuat1 where owner like 'OC_%';
 
select sequence_name as "AZKKUAT sequences" from dba_sequences where sequence_owner like 'OC_%'
 minus
 select sequence_name from dba_sequences@azkkuat1 where sequence_owner like 'OC_%'
 
select table_name "AZKKUAT tables" from dba_tables where owner like 'OC_%'
minus
select table_name from dba_tables@azkkuat1 where owner like 'OC_%';
select procedure_name as "AZKKUAT procedures" from dba_procedures where owner like 'OC_%'
 minus
 select procedure_name from dba_procedures@azkkuat1 where owner like 'OC_%';
 
select object_name as "AZKKUAT functions" from dba_objects where object_type='FUNCTION' and owner like 'OC_%'
 minus
 select object_name from dba_objects@azkkuat1 where object_type='FUNCTION' and owner like 'OC_%';
 
select view_name as "AZKKUAT views" from dba_views where owner like 'OC_%' 
 minus
 select view_name from dba_views@azkkuat1 where owner like 'OC_%';
 
select synonym_name as "AZKKUAT synonyms" from dba_synonyms where owner like 'OC_%'
 minus
 select synonym_name from dba_synonyms@azkkuat1 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@azkkuat1 where object_type='TRIGGER' and owner like 'OC_%';
 
select column_name as "AZKKUAT columns" from dba_tab_columns where owner like 'OC_%'
 minus
 select column_name from dba_tab_columns@azkkuat1 where owner like 'OC_%';
 

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: