Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
- From: amit bansal <amit.bansal82@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Wed, 21 Apr 2010 21:32:49 +0530
Expdp/impdp with include parameter will do job for you..
Cheers
Amit
On Wed, Apr 21, 2010 at 7:56 PM, nilesh kumar <nileshkum@xxxxxxxxx> 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
>
Other related posts:
- » Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- nilesh kumar
- » Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- Jost,
- » RE: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- Ojha, Ajeet (GE Healthcare, consultant)
- » Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- nilesh kumar
- » Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database - amit bansal
- » RE: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- Allen, Brandon
- » Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- Yechiel Adar
- » Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database- japplewhite