As long as you don't have conflicting table names you can use Public
Synonyms:
create synonym mytable for owner.mytable;
Kenny Gump
OCP 7.3 DBA
Erik Forkalsrud wrote in message <369FB7D7.C9AE324C_at_acim.com>...
>Thanks to everyone that answered my previous question. Here
>is another easy question for you.
>
>I'm new to Oracle and I'm trying to migrate an application from
>MS SQL 6.5 to Oracle 8.
>
>I used the Oracle Migration Workbench to migrate the users/tables
>to Oracle. On SQL Server, the owner of the tables was called sa,
>and this is also the owner in Oracle.
>
>In the existing application code, all users access the tables using only
>
>the names, like SELECT * FROM table_name, but int the Orcale database
>i need to add the table owner: SELECT * from sa.table_name;
>
>Is there any way I can skip the owner part in from of each table
>reference, so I don't have to rewrite all the queries throughout the
>application?
>
>Erik Forkalsrud
>
>______________________________________________
>Commission Junction - Partner With Us!
>Web: http://www.commission-junction.com
>Phone: 1.805.683.1522
>
>
Received on Mon Jan 18 1999 - 06:14:13 CST