Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: want to get table names from system tables
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
![]() |
![]() |