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-29929: missing SCAN Keyword

1 Answers  


TNS-00290: Navigator: Failed to Enable Interchange

1 Answers  


TNS-12570: TNS:packet reader failure

1 Answers  


ORA-01569: data file too small for system dictionary tables

1 Answers  


DRG-50943: query token too long on line string on column string

1 Answers  






ORA-31479: could not create LogMiner session

1 Answers  


PLS-00513: PL/SQL function called from SQL must return value of legal SQL type

1 Answers  


PLS-00309: with %%LAST attribute, 'string' must be a variable of an enumerated type

1 Answers  


NZE-28855: Unsupported SSL operation

1 Answers  


TNS-00125: Failed to get number of Interchanges in TNSNET.ORA

1 Answers  


ORA-30676: socket read or write failed

1 Answers  


ORA-02337: not an object type column

1 Answers  


Categories