Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-30026 – Undo tablespace string has unexpired undo with string(sec) left, Undo_Retention=string(sec)

Oracle Database Error Code ORA-30026 Description :

Undo tablespace string has unexpired undo with string(sec) left, Undo_Retention=string(sec)

Error Cause:

Tried to drop a tablespace that contains unexpired undo information

How to Solve :

lower setting of UNDO_RETENTION or wait a while before reissue command to drop undo tablespace