Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database

From: nilesh kumar <nileshkum@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>, oracle-l-admins@xxxxxxxxxxxxx
Date: Wed, 21 Apr 2010 19:56:57 +0530

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

Follow-Ups:
- Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: Jost,
- RE: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: Ojha, Ajeet (GE Healthcare, consultant)
- Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: amit bansal
- RE: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: Allen, Brandon
- Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: Yechiel Adar

Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database

Other related posts: