Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: mview/tablespace?
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-lReceived on Thu Jun 15 2006 - 08:19:43 CDT
![]() |
![]() |