Re: Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
From: Jost, <Joerg.Jost_at_unitrade.com>
Date: Wed, 21 Apr 2010 16:36:19 +0200
Message-ID: <1271860579.12458.9.camel_at_jost-laptop>
Am Mittwoch, den 21.04.2010, 19:56 +0530 schrieb nilesh kumar:
> 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 ?
>
Date: Wed, 21 Apr 2010 16:36:19 +0200
Message-ID: <1271860579.12458.9.camel_at_jost-laptop>
Am Mittwoch, den 21.04.2010, 19:56 +0530 schrieb nilesh kumar:
> 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 ?
>
Hi,
expdp und dbms_metadata jumps into my mind.
expdp knows a parameter named exclude and include where you can specify what kind of data should be exported. You should be able to transport the programms without the table data.
hth
Joerg Jost
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 21 2010 - 09:36:19 CDT