Hello,
I have a problem in a multi-schema enviroment.
My application needs to use some tables from the main schema and other from others "slave" schemas. The main schema is fixed but the "slaves" are dynamic at runtime.

Example:
I have the table main.foo that reference the table main.foo_element.
At runtime sometime I need to reference slave1.foo_element or slave2.foo_element.

There is a way to chage the reference schema only for a single transaction (Better)? or for a single session?

Tanks a lot
Lucio Tarantino

Hibernate version: 3.0.5

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