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: How can I show all the tables?

Re: How can I show all the tables?

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Wed, 11 Nov 1998 02:07:33 GMT
Message-ID: <Fj622.1869$vl4.1014943@tundra.ops.attcanada.net> 





Yes it is possible  to see all the table created by different users.



Select tablename, owner from  sys.dba_tables  group by  owner.




Nisar Tareen


Allianz Canada..




Derek Chu wrote in message >


>Is it possible for me to display all the tables created by a user?


>


>




Received on Tue Nov 10 1998 - 20:07:33 CST












Original text of this message













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