Moving Developement to Production...

Dear Gurus,

How to move packages from one server to other server. We have a development instance, and a production instance.

Right now my development instance one package is there. I want to move
development to Production (DEV to PROD)

Development Instance

SQL> select owner,object_name,object_type,status from dba_objects
2 where object_name = 'AR_RECEIPT_LIB_PVT';

OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------
----
OBJECT_TYPE STATUS
------------------ -------
APPS
AR_RECEIPT_LIB_PVT
PACKAGE VALID

APPS
AR_RECEIPT_LIB_PVT
PACKAGE BODY VALID


In This package now i want move to Production instance. How to move the packages from Development server to Production Server.

Thanks for any input.

Regards,
Iyyappan.M

Y do u want to move?

Copy the text of Package and complie in PRO Server.

Abhay.

The simplest way to do this for one package would be to spool the output from DBA_SOURCE for the package and run the resulting text file into your production system.

If you have tools such as OEM or TOAD you can simply copy and paste the code.

Regards

Using exp/imp utility we can do this. Generate the export dump file from DEV database. and then use imp into PROD database using rows=n ignore=y, packages will be created.

Hope this helps.

Hi,

Thanks for ur reply. How to export only packages in Test database to
Production Database.

Packages means - Package specification & package body

Can u please send me the script.

Thanks in advance,
Iyyappan.M

The developers must have the script when they were developing on the DEV database. Use the same script to create the package on PROD. Alternatively you can extract the code from DBA_SOURCE and create the script.

HTH
Sanjay

Quote:

---

Originally posted by iyyappan
Hi,

Thanks for ur reply. How to export only packages in Test database to
Production Database.

Packages means - Package specification & package body

Can u please send me the script.

Thanks in advance,
Iyyappan.M

---

You cannot export packages alone. You can do this way..

for instance you have user test:

do the export first from DEV database

exp test/pwd file=test.dmp owner=test log=testexp.log

and then import into PROD

imp test/pwd file=test.dmp fromuser=test touser=test rows=n ignore=y log=testimp.log

this will import objects, those are not available in PROD database.

NOTE : TRY ON YOUR TEST DATABASE PRIOR TO IMPLEMENT ON PROD DATABASE

Hope this helps.