Update an Oracle schema from another user


I want to know :

  • Is it possible to update an oracle schema when we loggin with another user ?

  • Is it possible to generate diffchangelog xml file between 2 schema from another user ?


answer to your first part is yes, as long as user you are logging in has appropriate privileges, else you will get errors.

I don’t know complete answer for your second question.