select username,default_tablespace from dba_users;

Regards

Deepak
----- Original Message -----
From: "akki " <oracledba-ezmlmshield-x34724213.[Email address protected]
To: "LazyDBA.com Discussion" <[Email address protected]
Sent: Wednesday, June 02, 2004 3:25 PM
Subject: to know schema;s tablespace


> 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