ORA-30027: Undo quota violation
From: Arpit Aggarwal <arpitdba2019_at_gmail.com>
Date: Thu, 9 Apr 2020 13:14:45 +0530
Message-ID: <CAOrSwErhmjSGDONNLiTrMvjJ52xkbe5t9su+EiSGeNb+y2xTfw_at_mail.gmail.com>
Hi Experts,
Date: Thu, 9 Apr 2020 13:14:45 +0530
Message-ID: <CAOrSwErhmjSGDONNLiTrMvjJ52xkbe5t9su+EiSGeNb+y2xTfw_at_mail.gmail.com>
Hi Experts,
My understanding tells me that such errors occurs only during DML's statements but in my case the error is happening during CREATE table and create index's statements. Is this normal ?
Every time I used to increase undo quota which resolved the problem for time being but error kept on coming after few days.
I have checked if undo_pool had any value set but I don't see any value which means it has been allocated unlimited value.
Can someone provide some recommendations on what should I look at as why it's happening during DDL's and how to resolve the error (apart from increasing undo quota every time)
Regards,
Arpit
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 09 2020 - 09:44:45 CEST