Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
Date: Thu, 22 Apr 2010 07:55:32 -0500
Message-ID: <OF7C0971F1.68467FDC-ON8625770D.0046E257-8625770D.0047021C_at_austinisd.org>
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_at_inter.net.il>
To:
Cc: ORACLE-L <oracle-l_at_freelists.org>
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_at_freelists.org
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-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 22 2010 - 07:55:32 CDT