Re: Problem ( ORA-03113) when dropping user with drop user cascade

From: Lorenzo del Río <lorenzo_del_rio_at_hotmail.com>
Date: 20 Mar 2002 07:00:27 -0800
Message-ID: <e4dbd2e9.0203200700.6d91b95f@posting.google.com>

Thanks a lot for your responses. After digging a little deeper I got that the problem is related with an Oracle bug that allows in certain conditions to RENAME an object that does not exist. That in turn makes the system dictionary corrupt and when dropping an entire user the system tries to drop some objects that in fact do not exist.

Some notes from oracle regarding this bug:

To know if the bug is hitting you
select owner#, name from obj$ where owner# not in (select user# from user$) and type# != 10;

If this returns rows and the RENAME command has been used on these objects you are seeing this bug.

From description of bug 1359472
Attempting a RENAME of a non-existent object can create invalid objects in the dictionary cache and data dictionary tables. This can show up later as an ORA-600 [15266]. A specific sequence of events is required to get into this state. Received on Wed Mar 20 2002 - 09:00:27 CST