Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: real oracle beginner
You need to have dba privileges to see the dba_??? objects.
You will probably be able to see user_tables.
Or as suggested by Jerome, tabs.
"davros" <dav.1_at_bigfoot.com> wrote in message
news:3CAD9E67.8010002_at_bigfoot.com...
> 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....
> >>
> >>
> >
> >
>
Received on Fri Apr 05 2002 - 07:30:13 CST