Schemas to Users in Oracle Physical Model
userIVMay 22 2012 — edited May 22 2012I created a relation model and sorted out the tables among the schemas. Now I am trying to create a physical model (Oracle 11g). It works and the tables are created in but there are only two Oracle users (PUBLIC & MDSYS). All the tables in the physical model have blank user (schema) field. Does it mean that I should create the users (schemas) again and sorted out the tables in the physical model?
I cannot find an option that allows me to transform the schemas in the relation model into the users in the physical model saving the links between the users and the tables.
Does this option (way) exist?
Regards,
userIV