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.