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@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."
