create undo tablespace UNDOTBS1 datafile 'C:\APP\RA\ORADATA\RA\UNDOTBS1.DBF' size 300M;
ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS1;
drop tablespace UNDOTBS2 including contents and datafiles;

select segment_name, tablespace_name, status from dba_rollback_segs where tablespace_name='UNDOTBS2'

SEGMENT_NAME                   TABLESPACE_NAME                STATUS         
------------------------------ ------------------------------ ----------------
_SYSSMU36_3515635829$          UNDOTBS2                       PARTLY AVAILABLE   
_SYSSMU37_1833855021$          UNDOTBS2                       OFFLINE          
_SYSSMU38_1310123677$          UNDOTBS2                       OFFLINE          
_SYSSMU39_3110269489$          UNDOTBS2                       OFFLINE          
_SYSSMU40_1231397611$          UNDOTBS2                       OFFLINE  

 alter database datafile ‘/app/oracle/oradata/RA/undotbs2.dbf’ offline drop;

 drop rollback segment "_SYSSMU36_3515635829$";
ORA-30025: Сегмент DROP '_SYSSMU36_3515635829$' (в табличном пространстве отмен) запрещен
30025. 00000 -  "DROP segment '%s' (in undo tablespace) not allowed"

select segment_name, tablespace_name, status from dba_rollback_segs where tablespace_name='UNDOTBS2'

SEGMENT_NAME                   TABLESPACE_NAME                STATUS         
------------------------------ ------------------------------ ----------------
_SYSSMU36_3515635829$          UNDOTBS2                       NEEDS RECOVERY  
_SYSSMU37_1833855021$          UNDOTBS2                       OFFLINE          
_SYSSMU38_1310123677$          UNDOTBS2                       OFFLINE          
_SYSSMU39_3110269489$          UNDOTBS2                       OFFLINE          
_SYSSMU40_1231397611$          UNDOTBS2                       OFFLINE  

truncate table ra_object_geodata

SQL Error: ORA-29859: возникла ошибка при выполнении программы ODCIINDEXTRUNCATE
ORA-13249: Stmt-Execute Failure: TRUNCATE TABLE RUSAGRO.MDRT_3BE7F$
ORA-29400: ошибка данных картриджа
ORA-00376: в данный момент файл 14 не может быть прочитан
ORA-01110: файл данных 14: 'C:\APP\RA\ORADATA\RUSAGRO\UNDOTBS2.DBF'
ORA-06512: на  "MDSYS.SDO_INDEX_METHOD_10I", line 43
29859. 00000 -  "error occurred in the execution of ODCIINDEXTRUNCATE routine"
*Cause:    Failed to successfully execute the ODCIIndexTruncate routine.
*Action:   Check to see if the routine has been coded correctly.

Alter tablespace UNDOTBS2 online;

SQL Error: ORA-01113: для файла 14 требуется восстановление носителя
ORA-01110: файл данных 14: 'C:\APP\RA\ORADATA\RA\UNDOTBS2.DBF'
01113. 00000 -  "file %s needs media recovery"

RECOVER DATAFILE 14;