Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA user in Oracle conflicts during migration

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US