RE: REPLICATION (816) of functions/procedure

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_at_rsiz.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh
> Sent: Thursday, September 02, 2004 11:44 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org&subject=unsubscribe
> To read recent messages -
> http://freelists.org/archives/oracle-l/09-2004
>
>
> ---
> To unsubscribe -
> mailto:oracle-l-request_at_freelists.org&subject=unsubscribe
> To read recent messages -
> http://freelists.org/archives/oracle-l/09-2004
>

---
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004