how can i create a schema alias?
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?
hardcoding the owner is a crap0la
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.
Or without the db link:
On the 'another' db:
CREATE USER RABBIT ...
GRANT ALL ON EMPLOYEES TO RABBIT;
CREATE SYNONYM EMPLOYEES FOR BUGSBUNNY.EMPLOYEES;
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
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).
Of couse it's feasible but then again are we gonna do that for every single table now and every single new tables?
Click Here to Expand Forum to Full Width