Re: How to export a package and a procedure

  • From: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
  • To: nileshkum@xxxxxxxxx
  • Date: Mon, 16 Jul 2007 10:47:42 +0300

Its very easy if you use DATAPUMPS.

Example:

expdp directory=<directory_name> dumpfile=<file.dmp>
include=procedure/fuction schema=<schemaname>

The above command unloads all procedure/function from the schema into
dumpfile.

And then create a sql file using the following:

impdp directory=<directory_name> dumpfile=<file.dmp> sqlfile=procedure.sql



On 7/14/07, nilesh kumar <nileshkum@xxxxxxxxx> wrote:

Hello All,

I have an issue i need to export a package and a procedure too which is
present in another package , is there any solution for this in datapump or
exp utility.Or is there any other solution for this to do pls help , i am
using 9i and 10g both .

Thanks
Nilesh soni




--
Best Regards,
Syed Jaffar Hussain
Oracle ACE
8i,9i & 10g OCP DBA

http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."

Other related posts: