Re: Hopefully easy question

Dan Cradler wrote:
>
> Working with sqlplus, is there a way to see what tables, indexes, etc. are
> available in the current schema? I am used to Informix and there is an
> easy way to do this in their dbaccess utility. I've looked at the help and
> don't see any command that would list tables and indexes in sqlplus.
>

  Try something similiar to this   

  SELECT index_name, table_name, table_owner     FROM all_indexes;

  In WHERE clause you should specify for example table_owner;

  Similiar views are all_tables

                     all_objects   
                     ....
                     and many and many others. For next
                     look for views in schema SYS

  What a shame, there's no user friendly way to get this   exceptt use SQL statements.     

--
   Happy Oracling 
                                                   Starous