Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: want to get table names from system tables

Re: want to get table names from system tables

From: Kev.- <java2e_at_yahoo.com>
Date: Wed, 16 May 2001 01:18:10 GMT
Message-ID: <3b01d53a.16795430@ns1.nothingbutnet.net>

Here is the query:

select table_name from all_tables where owner = 'OWNER NAME HERE';

On 15 May 2001 21:43:25 GMT, matthias.luettgert_at_risa.de wrote:

>Hello,
>I want to read the table names owned by a user from a oracle
>system table. Does anybody know, which system table contains the
>table names?
>
>Thanks,
>Matthias.
>
>--
>Matthias Luettgert, RISA Sicherheitsanalysen GmbH
>matthias.luettgert_at_risa.de
  Received on Tue May 15 2001 - 20:18:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US