Re: how to list all tables in sqlplus
From: Holger Kreft <Holger.Kreft_at_sutter.de>
Date: Fri, 24 Nov 2000 11:02:21 +0100
Message-ID: <3a1e3ccb$1_at_news.ic-marl.de>
Date: Fri, 24 Nov 2000 11:02:21 +0100
Message-ID: <3a1e3ccb$1_at_news.ic-marl.de>
Steve <sfang88_at_yahoo.com> schrieb in im Newsbeitrag:
3A1D95D6.788A44EB_at_yahoo.com...
> Where are these user_tables, all_tables, dba_tables, and dba_objects
created?
> My machine does have the user_talbes and all_tables but does not have
> dba_tables and dba_objects. Why? I was logged in as DBA/DBO.
Hi Steve,
user_tables, all_tables, dba_tables etc. are views of the schema SYS. Usually there are public synonyms for these views. Try e.g. "SYS.USER_TABLES" instead of just "USER_TABLES". Or create the synonyms.
hope to have been helpfull...
-- Holger Kreft ==================== Verlion GmbH, EssenReceived on Fri Nov 24 2000 - 11:02:21 CET