check if deleting the deleting the user, removes their schema and therefore all the objects tied to them.
That's expected and documented behaviour. When dropping tables, dependent objects like views or synonyms don't automatically get dropped.
Instead, the dependent objects get invalidated. This provides the option to check for invalidated objects after the base objects have been dropped. (E.g. system table VIEWS has a IS_VALID field).
With this information, you can create a list of invalid objects and make sure that all of them are corrected or deleted before you transport your development.
Add comment