We have Compaq ES40 machine with Digital Unix 4.0f
and recently we have migrated our Oracle database
from version 8.0.4 to 8.1.5. To upgrade we start
the instance with cold backup of 8.0.4 and upgrade
it to 8.1.5 through a script u0800040.sql. First time
while this script was running at the end we get the
message -
alter table system.repcat$_generated
add constraint repcat$_repgen_primary
ora-01041 internal error. hostdef
extension doesn't exist
We got this message for lot of system tables. But our
database start working fine and application tested
properly but when we try to drop an object of type 'TYPE'
then we got error message and WE ARE NOT ABLE TO DROP
A USER WHICH HAVE OBJECT AS TYPE 'TYPE'
eg. drop user scott cascade
we got the error
ora-00600 internal error code ,
arguments:[6002],[32],[6],[2],[0],[],[],[]


now we thought that there is some problem with our
oracle installation. So we reinstalled the oracle software , copied the 8.0.4 cold backup, ran the script
U0800040.sql (this time there was no ora 01041 error mentioned above) .the script ran successfully.
now when we try to drop any user which contain the object
type 'TYPE' we get the same error ora 600.
all remaining objects were dropped except object type 'TYPE'

this is the problem
this is very urgent
thanks