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: Procedure to migrate a procedure

Re: Procedure to migrate a procedure

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 13 Oct 2004 19:38:07 -0700
Message-ID: <1097721573.267150@yasure>


Richard Elliott wrote:

> I need to automate migrations of objects from one instance to another.
> I have the db links, but could use an example of a procedure or pl/sql
> to do the migrations. If possible I would like to just set up a single
> line for each object being migrated, vs. a cut and paste. Is there a
> standard way to do this ?
> Thanks in advance for the help.
>
> I have 8.1.7 and also have Toad 8 so I can set up an Oracle Job pretty
> easily.

Do you really have a need to reinvent the wheel?

Why not use the tools Oracle provides?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Wed Oct 13 2004 - 21:38:07 CDT

Original text of this message

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