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 available tables?

Re: Get all available tables?

From: John P. Higgins <jh33378_at_deere.com>
Date: Fri, 16 Oct 1998 19:35:02 -0500
Message-ID: <3627E635.AD4DA2F1@deere.com> 





Only a DBA can list all tables.



You can list all tables accessable by yourself from all_tables. This includes
your own tables and those to which you have been granted access.



You can list all tables owned by yourself from user_tables.



knez wrote:



> How can I get a list of all available tables and if possible rights to my


> Oracle 7.3.3 database.


>


> Thanks





Received on Fri Oct 16 1998 - 19:35:02 CDT












Original text of this message













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