ORA-30029: no active undo tablespace assigned to instance



ORA-30029: no active undo tablespace assigned to instance..

Answer / guest

Cause: the current instance does not have an active undo
tablespace assigned to execute transactions.

Action: ask DBA to create an undo tablespace, online the
undo tablespace and then retry operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12074: invalid memory address

1 Answers  


ORA-23319: parameter value string is not appropriate

1 Answers  


QSM-02050: subquery using the ALL clause in mv

1 Answers  


ORA-13415: invalid or out of scope point specification

1 Answers  


QSM-01058: MV, string, does not have column, string, for a joinback

1 Answers  






QSM-01087: query grouping on a column that cannot be derived from materialized view, string

1 Answers  


ORA-13204: failed to create spatial index table

1 Answers  


ORA-06142: NETTCP: error getting user information

1 Answers  


ORA-31191: Resource string is already checked out

1 Answers  


ORA-31441: table is not a change table

1 Answers  


ORA-23425: invalid materialized view identifier string

1 Answers  


ORA-38605: FI not enough memory(stringK) for candidate generation(stringK)

1 Answers  


Categories