Re: export procedures source codes via commandline
From: Chris O <itoys1>
Date: Wed, 24 Sep 2003 14:12:17 +1000
Message-ID: <3f7119a1$0$32058$afc38c87_at_news.optusnet.com.au>
Date: Wed, 24 Sep 2003 14:12:17 +1000
Message-ID: <3f7119a1$0$32058$afc38c87_at_news.optusnet.com.au>
"Harry" <harryooopotter_at_hotmail.co_> wrote in message
news:aY7cb.3138$AC3.161523_at_news2.telusplanet.net...
> I have two similar databases which I want to diff the
> source codes of procedures, packages, views, triggers, etc.
>
> I can use Toad to export the source codes and then do
> a diff.
>
> But I am looking for a way to do the export from commandline
> so eventually I can do it on Windows 2000's schedule tasks.
>
> The number of procedures, packages etc is over a hundred
> in each database.
>
> Is there a commandline tool take can do the export within
> an hour or so?
>
> TIA
>
Hi Harry.
- Since you are using TOAD, do you have the DBA module? My understanding is that it allows you to compare schemas. Additionally [I believe] there is a facility for scheduling jobs.
- Oracle Chamge Manager (CM) also has both thoses facilities. I'm not sure whether CM is still being bundled with the enterprise edition....it might be a product that you have to license separately these days.
Cheers Received on Wed Sep 24 2003 - 06:12:17 CEST