ORA-30026: Undo tablespace 'string' has unexpired undo with
string(sec) left, Undo_Retention=string(sec)



ORA-30026: Undo tablespace 'string' has unexpired undo with string(sec) left, Undo_Retent..

Answer / guest

Cause: Tried to drop a tablespace that contains unexpired
undo information

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


ORA-12927: RETENTION option already specified

1 Answers  


ORA-40222: data mining model export failed, job name=string, error=string

1 Answers  


NNL-00528: [set] password <password> : set the password for subsequent calls

1 Answers  


RMAN-06709: No scripts in recovery catalog

1 Answers  






TNS-01161: Spawn alias string was not found. Check listener parameter file

1 Answers  


ORA-04068: existing state of packagesstringstringstring has been discarded

1 Answers  


ORA-16752: Resource guard could not mount standby

1 Answers  


ORA-30430: list does not contain any valid summaries

1 Answers  


ORA-25455: evaluation error for rule set: string.string, evaluation context: string.string

1 Answers  


QSM-01572: equivalence, string, and query have different joins between tables, string

1 Answers  


ORA-36669: (XSDPART07) string is not a legal LIST partition.

1 Answers  


Categories