-
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?
thanks
-
no
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 ...
CONN BUGGSBUNNY/BBPW
GRANT ALL ON EMPLOYEES TO RABBIT;
CONN RABBIT/RPW
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?
-
yes
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|