RE: REPLICATION (816) of functions/procedure
- From: Rachel Carmichael <wisernet100@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 3 Sep 2004 05:34:25 -0700 (PDT)
May I make the point that having the script source in no way ensures
that you have the code as it is in the database you are copying from?
There are way too many people who make "quick fixes" without updating
source repositories. I've been known to do that myself, I freely admit.
I *always* take the source code from dba_source when I am replicating
packages/procedures/functions. This may be a case of DBA paranoia but
it takes no more time than pulling code from a source code repository
and allows me to sleep through the night after a change. There are
several good programs available (some free, some cost) that do that
easily and quickly.
Rachel
--- "Mark W. Farnham" <mwf@xxxxxxxx> wrote:
> Well, first I hope you actually have the script source used to create
> them
> originally.
>
> If not, you should be able to get the code out of dba_source.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
> Sent: Thursday, September 02, 2004 11:44 AM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: REPLICATION (816) of functions/procedure
>
>
> Hi,
> I want to replicate couple of functions and procedure from one
> database to
> another database.how to do this?
> thx
>
> _________________________________________________________________
> Don?t just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> ---
> To unsubscribe -
> mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
> To read recent messages -
> //freelists.org/archives/oracle-l/09-2004
>
>
> ---
> To unsubscribe -
> mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
> To read recent messages -
> //freelists.org/archives/oracle-l/09-2004
>
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
