Re: SqlBase, Informix ==> Oracle

Create 5 logons where each logon is the owner of the tables in the schema. Then you don't have to prefix the table name with the owner name. Jim
"Franky Thiel" <franky.thiel_at_infohos.be> wrote in message news:3bc58863$0$21080$ba620e4c_at_news.skynet.be...
> 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 - 16:19:28 CEST