Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 22 Apr 2010 08:50:33 +0300
Message-id: <4BCFE3A9.3050000_at_inter.net.il>
If you have TOAD with the DBA option you can do compare schemas and mark only the objects that you want to refresh.
Date: Thu, 22 Apr 2010 08:50:33 +0300
Message-id: <4BCFE3A9.3050000_at_inter.net.il>
If you have TOAD with the DBA option you can do compare schemas and mark only the objects that you want to refresh.
Adar Yechiel
Rechovot, Israel
nilesh kumar wrote:
> Hello DBA's
>
> Good Morning!!
> Hope everyone is doing a great job!!
>
> Here is one requirements from the client side to refresh only the
> procedures, package, and triggers of one schema which is in Prod
> database to the schema of Test database.
> I could have done the schema refresh but, the data in the Test is more
> then the Prod database and they dont want the data to be refreshed
> i see there is a very long list of the procedures,triggers etc...
> Please advise is there any solution we can do this ?
>
> Thanks
> Nilesh Soni
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 22 2010 - 00:50:33 CDT