Change Linked Oracle Table name not to include user prefix

[dpimental]

Is the a way to change the "user" prefix of a linked oracle table?

For example is you have 3 users : "tst", "dev" and "prd".
If you had an "orders" table, the following scenarios would happen.

login as tst, table name : orders_tst
login as dev, table name : orders_dev
login as prd, table name : orders_prd

I use a system dsn to define the login, user, password and tns service name. Is there any way to specify it so that I login as the user and the name of the table is the same "orders" regardless of what user I login as.

This would also help when relinking the table when moving between users.

David Pimental
(US, Oh)

 

[lameid]

Either change the name of the table progrmattically or cange the connect property programmatically.

In DAO this is the tabledef object.

If you change the connect property you need to use the refreshlink method to update the connection.