Re: How to export a package and a procedure

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_at_gmail.com> 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."

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