Query USER_SEGMENTS where SEGMENT_NAME='<mviewname>';
An MView is stored as a "Table" (and is also visible in USER_TABLES !!)
Query USER_INDEXES where TABLE_NAME='<mviewname>';

Hemant
At 09:07 PM Thursday, you wrote:
>Got a query that will map an mview to a tablespace? I don't.
>


Hemant K Chitale
http://web.singnet.com.sg/~hkchital


--
http://www.freelists.org/webpage/oracle-l