Re: To list all tables of a particular user??

In <1995Mar21.072114.4940_at_uxmail.ust.hk>, cs_henry_at_ug.cs.ust.hk (Chung Hoi Shan) writes:
>Hi,
>
>How can I list all the tables belong to a particular user?
>
>Any help would be appreciated.
>Henry (cs_henry_at_cs.ust.hk

select owner, object_name
from all_objects
where owner='your user' and object type='TABLE';

'your user' will be the user name you are querying.

M.Landa Received on Tue Mar 21 1995 - 16:07:31 CET