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

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)