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