Re: tables in sqlplus
From: Rafal Jank <yankee_at_wp-sa.pl>
Date: Mon, 19 Feb 2001 16:54:02 +0100
Message-ID: <3A91419A.CB82C6E5_at_wp-sa.pl>
Date: Mon, 19 Feb 2001 16:54:02 +0100
Message-ID: <3A91419A.CB82C6E5_at_wp-sa.pl>
> > >
> > > Hallo
> > > Do You how to display all tables that belong to database, using sqlplus
> > > tool
> > > greetings
> > select table_name from user_tables;
> > R.
>
> IIRC, not quite.
>
> select table_name from dba_tables;
>
> "user_tables" will give the tables that belong to the user, not all the tables
> in the database.
>
Yes, but I AFAIK you have to be DBA to access dba_tables...
-- _/ _/ _/_/_/ ----- Rafa³ Jank yankee_at_wp.pl ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==----------Received on Mon Feb 19 2001 - 16:54:02 CET