Re: basic sqlplus question

if you have DBA authority select table_name from sys.dba_tables otherwise select table_name from all_tables and you will see all tables you have authority on.

joe

Martin Meadows wrote:

> Hi. I'm an Oracle novice with a simple question. In sqlplus, is there a
> way to see a list of all the Oracle tables that are out there?
>
> Thanks for the information!
>
> Marty Meadows

--
Joseph S. Testa, Oracle Database Administrator, mailto:dba_at_oracle-dba.com
Vice-President Ohio Oracle Users Group, http://www.ooug.org
See the Oracle FAQ at http://www.orafaq.org
Try http://www.oracle-dba.com that is also the place to find the FREE, drop
column script
ICQ INFO: http://wwp.mirabilis.com/2832230
ICQ Email Express:  mailto:2832230_at_pager.mirabilis.com