Hi community,
we started upgrading our databases from 11g to 12c.
Until now we dropped schemas by <DROP USER xxx CASCADE>. <== on 11g there are no problems
On 12c we are not able to drop schemas, cause of error "ORA-04043 object SYS_PLSQL_xxxxx does not exist". Seemingly the import of a dump created serveral SYS_PLSQL_...-types. Deleting them manually solves the problem, so that the schema can be dropped. According to my investigation these types are concerned to packages.
Is there a way (a option, parameter, etc) to drop the schema with one statement (or prohibit Oracle to create the types), or must i ever drop the types manually before?
Thanks
Stefan