Re: real oracle beginner

it does not seem to like dba_tables

This is what i get

	cnndb:SQL> select table_name
	  2  from dba_tables
	  3  ;
	from dba_tables
	     *
	ERROR at line 2:
	ORA-00942: table or view does not exist

i am using sqlplus on an oralce 8i system any idea what i am doing wrong ?

thanks dav

Nick P wrote:

> Use the query:
>
> select table_name, owner
> from dba_tables
>
> the user_??? and dba_??? objects are very useful. It is worth finding your
> way around them.
>
> Immediate ones that might be of use are:-
>
> dba_tables
> dba_indexes
> dba_ind_columns
>
> Don't forget DESCRIBE <tablename> is very useful
>
> e.g.
>
> DESC MY_TABLE will give the structure of the table MY_TABLE
>
> Nick
>
> "davros" <dav.1_at_bigfoot.com> wrote in message
> news:3CAD6E0E.6060306_at_bigfoot.com...
>

>>sorry for such a lame question but i know my way around sql but have
>>never used oracle before
>>
>>how do i see what tables are in the current db i am in ?
>>
>>i have worked out that "describe Table_name" will tell table details but
>>i dont know what the tables are called
>>
>>thanks
>>
>>dav....
>>
>>