Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: listing all tables in a database??
You already got the equivalent (below). What problems do you have with it, provided there are no other ways than select from the dictionary, for which you have to get access to dba_tables?
Regards,
Sybrand Bakker, Oracle DBA
"hawk" <hawk_at_hotmail.com> wrote in message
news:92ho0b$605$1_at_bugstomper.ihug.com.au...
> For that I'll need to know the name of the table. That's the reason why I
> am looking for such a command as I don't know ALL the tables in the
> database. Basically, what I am looking for is an equivalent of 'ls' in
UNIX
> or 'dir' in DOS..
>
> Michael Puente <corky_at_skyinet.net> wrote in message
> news:AeZ26.6$vQ1.21029_at_news1.onlynews.com...
> |
> |
> | be a user with access to dba_tables
> | select table_name from dba_tables;
> |
> |
> | "hawk" <hawk_at_hotmail.com> wrote in message
> | news:92hn0m$5de$1_at_bugstomper.ihug.com.au...
> | > Hi all,
> | >
> | > Is there a way to list all the tables in a database. I use Oracle 7
for
> | > UNIX.
> | > Thanks
> | >
> | >
> |
> |
>
>
Received on Fri Dec 29 2000 - 05:35:46 CST