| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA user in Oracle conflicts during migration
In message <1108689867.689500.147750_at_g14g2000cwa.googlegroups.com>,
TheanKeong <theankeong_at_gmail.com> writes
>Thanks Jim for the advice,
>
>I have given this a deep thought also, but the fact of having to
>revisit all my program codes to change the SQL statements is simply a
>task i cant imagine to be possible due to the complexity of my program.
>I have thousands of such statements refering dba as the owner of the DB
>in my program, the effort to revisit each one will take eternity.
>
>Is there any other options besides this one ?
>(i know i am clinging on false hope here, but hope its worth a shot)
>
>Thanks
>TheanKeong
>
That sounds like poor design and poor programming practice. The normal
practice with Sybase is to have the objects owned by dbo which means
they can be referred to without a prefix. Your SQL statements should be
collected in a few modules rather than scattered throughout the code.
The only thing you can do is
migrate the database, renaming the user as I suggested
create SYNONYMS for all objects
edit your source to remove all references to dba. and just leave
the plain table names.
As Noons suggested elsewhere, a half decent editor should be able to do global search and replace on multiple files quite easily.
-- Jim Smith Because of their persistent net abuse, I ignore mail from these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw For an explanation see <http://www.jimsmith.demon.co.uk/spam>Received on Fri Feb 18 2005 - 03:18:59 CST
 |
 |