Pessoal, Consegui resolver isso fazendo um export da tablespace.
. . exported "PRODUCAO"."S_SGE_MENU_DIVISOES" 0 KB 0 rows SQL> drop materialized view S_SGE_MENU_DIVISOES; Materialized view dropped SQL> DROP TABLESPACE SNAP INCLUDING CONTENTS AND DATAFILES; Tablespace dropped Grato, Ednilson Silva De: oracle_br@yahoogrupos.com.br [mailto:oracle_br@yahoogrupos.com.br] Enviada em: sexta-feira, 21 de agosto de 2015 16:05 Para: oracle_br@yahoogrupos.com.br Assunto: [oracle_br] ORA-23515: materialized views and/or their indices exist in the tablespace Pessoal, Estou tentando excluir uma tablespace e esta ocorrendo abaixo, alguém pode dar uma ajuda? SQL> drop tablespace snap including contents and datafiles; drop tablespace snap including contents and datafiles * ERROR at line 1: ORA-23515: materialized views and/or their indices exist in the tablespace SQL> select 'drop materialized view' || owner || '.' || segment_name || ';' from dba_segments where segment_name in (select mview_name from dba_mviews) and tablespace_name = 'SNAP'; no rows selected SQL> select OWNER, SUBSTR(SEGMENT_NAME, 1, 35) SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, ROUND(BYTES / 1024 / 1024) MB FROM dba_segments WHERE TABLESPACE_NAME = 'SNAP'; 2 3 4 5 6 7 OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME MB ------ -------------- --------------- ---------------- ----- SYS 145.122 SPACE HEADER SNAP 1 SQL> select * from v$version; BANNER ---------------------------------------------------------------------------- ---- Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production CORE 11.2.0.4.0 Production TNS for Linux: Version 11.2.0.4.0 - Production NLSRTL Version 11.2.0.4.0 - Production Grato, Ednilson Silva
