Re: Can I list all the tablespaces in oracle

Query dba_tablespaces and have a look at dba_segments or dba_objects to view what is actually stored in these tablespaces...

Robert

On Wed, 12 May 1999 16:47:33 +1000, Shi yousong <yousong_at_bigpond.com> wrote:

>Hi ,
>
>I think there should be a way to list all the online tablespaces in the
>oracle server, including the schemas existing in each tablespace. Can
>anyone tell me the SQL command ?
>
>Thanks in advance.
>
>
>regards,
>
>Sam
>
Received on Wed May 12 1999 - 07:01:00 CDT