Re: NEWBIE: SQL intro

In article <8sf862$jfu$1_at_nnrp1.deja.com>,   Paul Bennett <spacey845_at_my-deja.com> wrote:
> Very stupid newbie question about SQL.
>
> I've tried RTFM, but I need a faster and more concise answer than the
> docs supply (or at least a helping hand on where in the docs to start
> looking to find a concise answer?)
>
> How do I list the tables/tablespaces/views defined in my database,
> using svrmgrl (local SQL Plus prompt)? I need to check this locally,
> as I'm trying to figure out whether it's the database or the client
> that is wrongly configured.
>
> TIA,
>
> ---
> Pb
> My opinions are my own and should not be taken as
> representing any other group or entity.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Try this:

select owner, table_name, tablespace_name from all_tables;

This will provide the tables and associated tablespaces in the instance.

To report the views existant in the instance:

select owner, view_name
from all_views;

To report all tablespaces in the instance:

select tablespace_name
from dba_tablespaces;

If you need further information you can email me privately (oratune_at_aol.com).

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.