Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
Hibernate 3.0

Name and version of the database you are using:
Oracle 9i

I have this condition where i need to update a table that is not in my own schema of the database but lies in some other schema.

Does any one know whether there is a possibility of updating or inserting new data in a table that exists in another schema of the Database other than the one where your application's hibernate.cfg.xml points.

Technically : no problem. You just have to declare a SessionFactory object for each database. Then just get a session of the right SessionFactory to apply your request, and you're done.

The only thing is : I think that if you want to do a transaction including insertion in one schema, then another, it's called a two phase commit and I don't know if it's easily manageable, 'cause I've never done it.

But without this, you should manage to do what you want with not too much difficulties.