Re: mview/tablespace?

On 6/15/06, Ray Stell <stellr_at_cns.vt.edu> wrote:
>
> Got a query that will map an mview to a tablespace? I don't.
>
> SQL> drop tablespace fred including contents and datafiles;
> drop tablespace FRED including contents and datafiles
> *
> ERROR at line 1:
> ORA-23515: materialized views and/or their indices exist in the tablespace
>
> I worked around this in another fashion, but I couldn't find this
> map quickly.
>
> No gui junk please.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> Haven't tested this - but isn't it just DBA_MVIEWS joined to DBA_SEGMENTS
on mview_name or container_name ?

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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