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

  • From: nilesh kumar <nileshkum@xxxxxxxxx>
  • To: "Ojha, Ajeet (GE Healthcare, consultant)" <Ajeet.Ojha@xxxxxx>
  • Date: Wed, 21 Apr 2010 20:37:36 +0530

Thank you!!

On Wed, Apr 21, 2010 at 8:09 PM, Ojha, Ajeet (GE Healthcare, consultant) <
Ajeet.Ojha@xxxxxx> wrote:

> Export  , import or data pump if oracle 10g.  don't export data , just
> metadata and then import with show = yes .....there are options of
> object type as well...in data pump. So don't choose tables . you can
> exclude them..
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of nilesh kumar
> Sent: Wednesday, April 21, 2010 7:57 PM
> To: ORACLE-L; oracle-l-admins@xxxxxxxxxxxxx
> Subject: Need to refresh only the procedures, pacakes and triggers from
> Production with effecting the Tables in Test database
>
> 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
>
>

Other related posts:

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