Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Some Lateral thinking Required - Hard-Coded instance workaround
Johne_uk wrote:
> Thanks for the replies guys.
>
> I've just found out that the app uses a connection string (no tnsnames)
> so that rules out using tnsnames.The orany1 database is going to be
> scrapped and rebuilt again in the future so the option of connecting to
> orany2 and using db link / synonyms to point to orany1 cannot be used
> (good idea though). Our development is done offshore and we would be
> charged for these changes which is not worth it for the short time we
> need to relocate the app. I agree its bad practise and I believe none
> of other others apps have hard-coded references.
>
> I did trying connecting directly to orany2 and creating synonyms that
> reference table_at_orany2 for any reference to table_at_orany1 in the code
> but it refuses to work.
>
> Thanx again
> John
Charged? I would tell the off-shore hackers that they delivered a defective product and that if they don't make good there are plenty of other two-bit hackers to choose from. In short ... fix it now and fix it for free or you are fired. They'll fix it. Then find another someone else to work with in the future. One can only wonder at the number of other bad-practices they wrote into their app.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Apr 18 2006 - 10:51:23 CDT