Showing posts with label ORA-30029. Show all posts
Showing posts with label ORA-30029. Show all posts

Friday, 18 May 2012

ORA-30029: no active undo tablespace assigned to instance

ORA-30029: no active undo tablespace assigned to instance

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.