Skip to main content

Find Owner of an Oracle Table


This helps in getting the right schema


select owner
     , object_name
     , object_type
  from ALL_OBJECTS

 where object_name IN ( 'table1' , 'table2' ) 
 AND OBJECT_TYPE IN ( 'TABLE' , 'VIEW' ) 

Comments

Popular posts from this blog