Re: migrating types between users on the same oracle instance

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 09 Aug 2007 16:03:57 -0500
Message-ID: <46bb7522$0$16263$88260bb3@free.teranews.com>

julian.kania_at_gmail.com wrote:
> On 9 Sie, 20:24, DA Morgan <damor..._at_psoug.org> wrote:

>> julian.ka..._at_gmail.com wrote:
>>> I have two environments - test and dev - on the same oracle instance,
>>> but on different users.
>>> I need to migrate test to dev with a shell script.
>> I can think of a number of good ways to do it ... not one involves a
>> shell script.

> Can you please point some?
> Involving java or perl is totally acceptable.
> Or must be Windows / X window used?
>

>> Any reason why you are required to do it the hard way?

> There is a need of such migration often. In the fact, we have much
> more environments than two, and populating db is only a part of whole
> process.
> The rest works smoothly and extremely easy: ./migrate.pl <from> <to>
>
>
> julian.
>

I would look at implement a PL/SQL routine to do this and then schedule it with DBMS_SCHEDULER. That way, the job will only run when the database is up.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Thu Aug 09 2007 - 16:03:57 CDT