Suppose I need to define to have 2 separate databases backed on the Oracle: DBCustomers and DBProducts.
In DBCustomers I want to have tables: PersonalData and Orders.
In DBProducts I want to have tables: ProductData and Distribution.
My persistence.xml now:
The problem is that when I run it, both databases have all four tables: PersonalData, Orders, ProductData and Distribution. I want to separate these tables as I described in the beginning of this post.
Is there a way to do that?
Joined: Feb 15, 2007
PS. As you can see, the IP address of host with Oracle is the same for both databases - only user differs. But as far as I know, different users in the Oracle have different schemas.