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
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