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

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP- How to find all tables created by a user?

Re: HELP- How to find all tables created by a user?

From: Mechanical Mann <eric_at_REMOVE_SPAMspeco.com>
Date: Tue, 19 Feb 2002 15:29:09 -0600
Message-ID: <a4ug4v$ras$1@bob.news.rcn.net> 





  SELECT  TABLE_NAME



     FROM  SYS.ALL_TABLES



  WHERE  OWNER LIEK 'user-name';




"Mario King" <hliji_at_usa.net> wrote in message
news:1ba32e56.0202191321.365877c7_at_posting.google.com...


> Hi,

>

> I know the user/password pair of an Oracle user. How do I show all

> the tables he created - I'm not a DBA and don't have sys password.

>

> Thanks.

Received on Tue Feb 19 2002 - 15:29:09 CST












Original text of this message













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