Re: List of all Tables?
Date: Mon, 16 Jul 2001 03:29:06 GMT
Message-ID: <3B5262F0.B6A5C9B1_at_telusplanet.net>
View 'CAT' has been around for a long, long time - with the warning that itr may disappear sometime.
The 'correct' way would be to use one of the views
USER_TABLES - all tables 'owned' by the current user ALL_TABLES - all tables 'accessible' to the current user DBA_TABLES - 'all' tables, including ownership, only works if you use it from an account with DBA privs.
/Hans
James Pittman wrote:
> Gerat - thanks!
>
> Jamie
>
> Eric from Speco wrote:
>
> > SELECT * FROM CAT
> >
> > James Pittman <jlp_at_swl.msd.ray.com> wrote in message
> > news:3B447D57.372A5CF0_at_swl.msd.ray.com...
> > > Hi,
> > > In SQLPlus, is there a command to display a list of all tables?
> > >
> > > Thanks,
> > > Jamie (Oracle Newbie)
> > >
Received on Mon Jul 16 2001 - 05:29:06 CEST