| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> mview/tablespace?
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-lReceived on Thu Jun 15 2006 - 08:07:56 CDT
 |
 |