Search This Blog

Tuesday, December 20, 2011

difference of objects in 2 schemas

select table_name, index_name from dba_indexes where owner='owner1' minus select table_name,index_name from dba_indexes where owner='owner2'
/

No comments:

Post a Comment