Re: To list all tables of a particular user??
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/03/30
Message-ID: <Pine.SUN.3.91.950330085213.21583A-100000_at_seatimes>#1/1
Date: 1995/03/30
Message-ID: <Pine.SUN.3.91.950330085213.21583A-100000_at_seatimes>#1/1
On Tue, 21 Mar 1995, Chung Hoi Shan wrote:
>
> How can I list all the tables belong to a particular user?
If you are the user connected, then the following will show you all your tables:
SELECT * FROM USER_TABLES; If you are the DBA or have access privileges to DBA_TABLES then
SELECT * FROM DBA_TABLES WHERE OWNER = 'user name';
You can do a SELECT * FROM DICT to get a listing of available system tables.
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Mar 30 1995 - 00:00:00 CEST