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-02772: Invalid maximum server idle time

1 Answers  


ORA-15068: maximum number of diskgroups string already mounted

1 Answers  


NNL-01001: NAME EXISTS responses received: number

1 Answers  


ORA-15186: ASMLIB error function = [string], error = [string], mesg = [string]

1 Answers  


ORA-07440: WMON process terminated with error

1 Answers  






ORA-00822: MMAN process terminated with error

1 Answers  


ORA-30574: Cannot create rollback segment in tablespace with AUTO segment space management

2 Answers  


ORA-02142: missing or invalid ALTER TABLESPACE option

1 Answers  


DRG-10573: index string is obsolete

1 Answers  


TNS-01030: The listener supports no services

1 Answers  


ORA-22819: scope of input value does not correspond to the scope of the target

1 Answers  


QSM-00754: task string does not reference a valid workload and therefore cannot be executed

1 Answers  


Categories