Re: DBA user in Oracle conflicts during migration

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 17 Feb 2005 19:38:00 -0800
Message-ID: <1108697880.024056.75100@g14g2000cwa.googlegroups.com>

TheanKeong wrote:

> 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.

Use one line of vim to global edit your source? :g/dba/s//anything_else/g
or two:
:g/DBA/s//anything_else/g

.
.
.

> Is there any other options besides this one ?
> (i know i am clinging on false hope here, but hope its worth a shot)

Not that I know of. Sorry. Received on Thu Feb 17 2005 - 21:38:00 CST