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

  • From: "Ojha, Ajeet (GE Healthcare, consultant)" <Ajeet.Ojha@xxxxxx>
  • To: <nileshkum@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>, <oracle-l-admins@xxxxxxxxxxxxx>
  • Date: Wed, 21 Apr 2010 20:09:24 +0530

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

--
//www.freelists.org/webpage/oracle-l

Other related posts:

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