mview/tablespace?

  • From: Ray Stell <stellr@xxxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 15 Jun 2006 09:07:56 -0400

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


Other related posts: