execute this.

select username, default_tablespace from dba_users;

.For more info query other columns of dba_users..

akki wrote:

> hi all....
>
> how can we know the tablespace being used by particulars schema
>
> thanks
> akki
>
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page