Prepare to Change Ownership of a Database Object
Before changing ownership of a database object, take the following preparatory steps:
1. Make sure you have a current backup of the database.
2. Check whether the user already owns an object with the same name as the object whose ownership you are changing.
If this is the case, the existing duplicate object must be destroyed before proceeding.
Important! If you fail to do this, the new object, owned by the new user, cannot be successfully created, and you can potentially corrupt the existing object with unwanted data.