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

  • From: japplewhite@xxxxxxxxxxxxx
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 22 Apr 2010 07:55:32 -0500

Check out the Data Pump utilities - expdp and impdp - if you're on 10g or 
above.

Jack C. Applewhite - Database Administrator
Austin I.S.D. - MIS Department
512.414.9715 (wk)  /  512.935.5929 (pager)




From:   Yechiel Adar <adar666@xxxxxxxxxxxx>
To: 
Cc:     ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date:   04/22/2010 12:58 AM
Subject:        Re: Need to refresh only the procedures, pacakes and 
triggers from   Production with effecting the Tables in Test database
Sent by:        oracle-l-bounce@xxxxxxxxxxxxx



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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2010