Re: Can I list all the tablespaces in oracle

Hi,

Look at my web page http://home.earthlink.net/~vit100gain/ you'll find it there.

Vitaliy Mogilevskiy

rpdata_at_cyberus.ca wrote:

> 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 - 11:59:46 CDT