On 6/15/06, Ray Stell <stellr@xxxxxxxxxx> 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. -- //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@xxxxxxxxx web: http://www.oracledba.co.uk