My Oracle Diary
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment