ORA-23515: Materialized Views and/or Their Indices Exist in the Tablespace
(Doc ID 1624253.1)
Last updated on JULY 16, 2019
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later Information in this document applies to any platform.
Drop tablespace failed with below error :
SQL> DROP TABLESPACE APPS_TS_TX_DATA INCLUDING CONTENTS AND DATAFILES; DROP TABLESPACE APPS_TS_TX_DATA INCLUDING CONTENTS AND DATAFILES * ERROR at line 1: ORA-23515: materialized views and/or their indices exist in the tablespace
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!