Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Accessing other users' tables
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