Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: mview/tablespace?

Re: mview/tablespace?

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 15 Jun 2006 21:19:43 +0800
Message-Id: <6.2.1.2.0.20060615211813.01fb3b40@pop.singnet.com.sg>

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
Received on Thu Jun 15 2006 - 08:19:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US