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

From: "Jost," Jörg <Joerg.Jost@xxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 21 Apr 2010 16:36:19 +0200

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

References:
- Need to refresh only the procedures, pacakes and triggers from Production with effecting the Tables in Test database
  - From: nilesh kumar

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

Other related posts: