SqlBase, Informix ==> Oracle

Now we are working with SqlBase and Informix and have created a 5 databases for 1 project. We now want to convert to Oracle but in Oracle you create 1 database and in that database you create 5 times a schema. The problem is that we have tables with the same name in schema 1 and in schema 3. In Sqlbase it was in database 1 & 3. If we create public synonyms in Oracle whe have a problem because some tables exists in database 1 & 3.

If we want to do a select in Oracle we must do SELECT ..... FROM owner.tablename instead of SELECT ... FROM tablename and that's because we cannot create the public synonyms.
Is there another solutions for this because otherwise we had to change all our select statements in our applications.

Thanks for your help,

Franky Received on Thu Oct 11 2001 - 13:54:12 CEST