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: Get all the table of another user

Re: Get all the table of another user

From: Powerup News <ghealy_at_powerup.com.au>
Date: Mon, 14 Feb 2000 23:52:02 +1000
Message-ID: <38a807c0@grissom> 





Try


Select * From all_tables where owner = 'ora_user';



Gary.


Dirk Poppke wrote in message <888snm$r1c$1_at_fbi-news.cs.uni-dortmund.de>...


>Hi there!


>


>I would like to display all the owned Table of a different user with Oracle


>8.1.5.


>Any Ideas!?


>


>Thanks,


>Dirk


>


>




Received on Mon Feb 14 2000 - 07:52:02 CST












Original text of this message













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