--- CONSULTA los tablespaces
-- SELECT * FROM DBA_DATA_FILES ORDER BY TABLESPACE_NAME;
-- consulta indices de esquema en el tablaspace tbspacex
-- SELECT * from all_indexes where TABLESPACE_NAME = 'tbspacex' AND STATUS='UNUSABLE'
-- consulta indices de esquemas en el tablaspace tbspacex2,
-- SELECT * from all_indexes where TABLESPACE_NAME = 'tbspacex2' AND STATUS='UNUSABLE' ;
No hay comentarios:
Publicar un comentario