Oracle Error Message
ORA-42297: cannot drop a schema synonym for a schema of a user who is currently connected
Reason for the Error
An attempt was made to drop a schema synonym for a schema of a user who was logged on.
Solution
Make sure user is logged off, then repeat command.