0 Replies Latest reply on Jan 28, 2004 2:36 PM by timmytool

    Oracle Multiple schemas in same database with same tables CM

    timmytool Newbie

       

      "Timmytool" wrote:
      We have a development environment with mutliple schemas. We all have a copy of the same tables for development purposes.

      We don't want to turn off the security so that users can't see each others tables.

      We are getting errors because the CMP container sees that the table already exists for a bean and doesn't create it. I tried prepending the table name with schema and the container always tries to create the table. Cause when it does its select table_name from all_Tables it doesn't find schema.table.

      Anyone know a good way to have this work?