Problem with Schema - User prefix in Oracle
Posted: Fri 29 May 2009 11:17
Hello,
If i generate the classes using the O-R tool, each business class e.g. Customer gets a Table attribute in which the name of the table is prefixed by the relevant default schema E.g. SCHEMA1.CUSTOMERS. If i use a different schema when i instantiate the DataContext class, data for Customers are still retrieved from the SCHEMA1.CUSTOMERS table!!! Both users have DBA priviledges and i think this is the reason behind the visibility of the old schema. If i change the attribute to point to a non existent schema, i get an error "table or view does not exist". It seems to me, that the tool should not prefix the table name with a user. If i just delete the schema prefix, everything works as expected.
If i generate the classes using the O-R tool, each business class e.g. Customer gets a Table attribute in which the name of the table is prefixed by the relevant default schema E.g. SCHEMA1.CUSTOMERS. If i use a different schema when i instantiate the DataContext class, data for Customers are still retrieved from the SCHEMA1.CUSTOMERS table!!! Both users have DBA priviledges and i think this is the reason behind the visibility of the old schema. If i change the attribute to point to a non existent schema, i get an error "table or view does not exist". It seems to me, that the tool should not prefix the table name with a user. If i just delete the schema prefix, everything works as expected.