OraFAQ Forum: SQL & PL/SQL » user sys to query the name of tables created by other user

Home » SQL & PL/SQL » SQL & PL/SQL » user sys to query the name of tables created by other user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user sys to query the name of tables created by other user [message #23358]

Wed, 04 December 2002 02:40

Armando
Messages: 6
Registered: December 2002

Junior Member

being a user sys(dba) how can i query the names of all tables created by a certain user.

i tried this query command but it gave me an error output.
select * from scott.tab;

thanks in advance,
armando

Report message to a moderator

Re: user sys to query the name of tables created by other user [message #23380 is a reply to message #23358]

Wed, 04 December 2002 12:06

ann
Messages: 24
Registered: August 2000

Junior Member

try select * from dba_tables...who is the owner of the table? Sys, apps, applsys....etc.

Report message to a moderator

Re: user sys to query the name of tables created by other user [message #23383 is a reply to message #23358]

Wed, 04 December 2002 19:36

Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA

Senior Member

Query to select the names of all tables created by user SCOTT:

SELECT table_name
FROM all_tables
WHERE owner = 'SCOTT';

Report message to a moderator

Re: user sys to query the name of tables created by other user [message #23394 is a reply to message #23358]

Thu, 05 December 2002 02:16

Armando
Messages: 6
Registered: December 2002

Junior Member

thank you very much for your answer.

regards,
armando

Report message to a moderator

Previous Topic:	Informix -> Oracle migration
Next Topic:	Create a Database link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 00:42:48 CDT 2024