Re: NOVICE - How to get a list of tables in DB
From: Balakrishna Avula <100610.52_at_compuserve.com>
Date: 1996/03/22
Message-ID: <4iu4j5$b7o_at_relay2.uk.mdis.com>#1/1
Date: 1996/03/22
Message-ID: <4iu4j5$b7o_at_relay2.uk.mdis.com>#1/1
gallagher_at_nm-us.campus.mci.net (Mike G) wrote:
>This is a question from a beginning ORACLE user.
>I need to find out how to find out how to get a listing of all the owners of
>database tables and all the tables that our organization has.
>What this translates to is that I need something for tables that is analagous
>to the DIRECTORY listing of files on a hard drive.
>Tables are referenced as owner.table_name e.g., finance.orders or
>gwb.wells. But I can't reference them unless I know what they are!
>Thanks, Mike
Select owner, table_name
from dba_tables
order by 1,2
Submit the above statement after logging in as a dba, ie SYS, SYSTEM account etc.
Bala
-- Balakrishna Avula 28 Ashby Court Alpha-Tek Associates Ltd. Hemel Hempstead Technical Consultant HERTS HP2 7QL 100610,52 on Compuserve UK http://ourworld.compuserve.com/homepages/BAvula/homepage.htm on WWWReceived on Fri Mar 22 1996 - 00:00:00 CET