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: Yan Lin <yongyl_at_novasprint.com>
Date: Wed, 16 May 2001 17:10:16 +0800
Message-ID: <3b0244b7.0@news.tm.net.my>

Hi Matthias,

Tr y to query

select table_name from dba_tables where owner='Owner1'

Best Regards
Stephanie

matthias.luettgert_at_risa.de wrote in message <9ds7tt$c6v$2_at_amun.combox.de>...
>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 Wed May 16 2001 - 04:10:16 CDT

Original text of this message

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