Skip to Content
Former Member
Dec 05, 2008 at 12:21 PM

Oracle Error : ORA-23515 , while droping the table space


Hi All,

When I am droping the table sapce then getting the following error and not able to drop the table space :

Oracle Error : ORA-23515: materialized views and/or their indices exist in the tablespace

Could you please let me know that how can I check the which materialized views those are existing in that table space so that I can delete those before deleting the table space.

Thanks in advance.