how can i create a schema alias?

[challsql]

the application is pointing to RABBIT.EMPLOYEES

the data has been migrated to another db pointing to BUGSBUNNY.EMPLOYEES

it ist possible to have BUGSBUNNY look like RABBIT so the code in the application doen't have to change?

thanks

[pando]

no

hardcoding the owner is a crap0la

[Axr2]

Pando - why do you say no? Technically it is feasible, right? I agree that the design/architecture is crapola.

Simply create a view over a dblink and then a synonym for it. Finito.

[LKBrwn_DBA]

Or without the db link:

On the 'another' db:

CREATE USER RABBIT ...

CONN BUGGSBUNNY/BBPW

GRANT ALL ON EMPLOYEES TO RABBIT;

CONN RABBIT/RPW

CREATE SYNONYM EMPLOYEES FOR BUGSBUNNY.EMPLOYEES;

[Axr2]

The reason I didn't suggest that was the application will need to be modified to point to the new database. S/he seemed reluctant to touch the application. Given that, the dblink will work 'best'. (Although performance goes for a toss).

[pando]

Of couse it's feasible but then again are we gonna do that for every single table now and every single new tables?

[Axr2]

yes