Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> distinct(object_type) from dba_objects in SQL
Hi There
I'm looking for a count of each distinct(object_type) from dba_objects where owner not in ('SYS','SYSTEM','DB_SNMP'). I'm going to use it to compare prod,test,dev databases across multiple instances but i'm a little stuck on the supposed easy part.
Thanks
Mike
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Dec 09 1999 - 17:18:53 CST