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: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Thu, 15 Jun 2006 22:04:24 +0800
Message-ID: <5e3048620606150704n69f62c6ft68f2492048a334d8@mail.gmail.com>


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
Received on Thu Jun 15 2006 - 09:04:24 CDT

Original text of this message

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