Re: QUestion: how to list all the tablespaces?

Grace Tsai <gtsai_at_bnl.gov> wrote:

>Hi,
>
>This is a really elementary question. What is the command to list all
>the tablespaces in the database? Thanks.
>
>Grace

If DBA you can use

Select distinct tablespace_name from dba_tables order by tablespace_name;

Variants will be
all_tables ( all tables the user logged in has access to) user_table ( tables owned by logged in user) - These will limit the tablespaces you get back to those used by the table in the set.. Received on Wed Dec 15 2004 - 14:47:02 CST