Review the error messages that are displayed when trying to modify the ownership, group membership, or permission of a file fails while changing a file's owner.

The following error messages are displayed:

ORA-15301

cannot change %s of the open file '%s'

Cause: A SET OWNERSHIP or SET PERMISSION command was attempted on an open file.

Action: Close the file and retry the SQL command.

ORA-15302

active use of files owned by user '%s' precludes its drop

Cause: A DROP USER command specified a user owning files that were in use.

Action: Close all files owned by this user.