Re: Oracle table listing question

From: Alvin Nonaka <xea0005_at_co.honolulu.hi.us>
Date: 1996/04/02
Message-ID: <Dp7MDH.B0K_at_news.hawaii.edu>#1/1


For a person with dba privilege:

 select table_name from sys.dba_tables
 where owner = '<NAME IN ALL CAPS>';

You can double check this by signing under the person's usercode and issuing:

 select table_name from tabs;

aloha
ayn Received on Tue Apr 02 1996 - 00:00:00 CEST

Original text of this message