Re: Newbie - How can I list all the tables in a schema?

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/12/06
Message-ID: <32a87e9e.11104837@dcsun4>#1/1

On 6 Dec 1996 18:44:49 GMT, earvin_at_omega.uta.edu (Earvin C. Lim) wrote:

select object_name, object_type, status
from all_objects
where owner = 'SOMEONE'
/

that'll give you more then just tables, You can get just tables from the all_tables view.

>How can I list all the tables in a schema?
>
>Thanks!
>
>--
>Earvin Lim
>-- Programmer/Analyst
>-- Academic Computing Services
>-- University of Texas at Arlington
>email: earvin_at_omega.uta.edu
>Phone: (817)272-3678

Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com                          

http://govt.us.oracle.com

• Check out Oracle Governments web site! ----- Follow the link to "Tech Center" and then downloadable Utilities for some free software...

  ---

statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Fri Dec 06 1996 - 00:00:00 CST