Home » SQL & PL/SQL » SQL & PL/SQL » Export
icon4.gif  Export [message #436381] Wed, 23 December 2009 04:20 Go to next message
mjkreddy1927
Messages: 20
Registered: February 2007
Junior Member
Hi Friends ,

I want to move the packages,functions,procedures from one server/schema to other server schema.

we can do this using simpe export and import if so please let me any other ways to do so.

*only procs,pack's,Functions.

please help me its quite urgent.

thanks and regards
jk
Re: Export [message #436383 is a reply to message #436381] Wed, 23 December 2009 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't with exp/imp.
Use dbms_metadata.get_ddl

Regards
Michel
Re: Export [message #436384 is a reply to message #436381] Wed, 23 December 2009 04:29 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_datpmp.htm#BABJACDG

<quote>
please help me its quite urgent.
</quote>

Also, from next time if you could tell us how urgent it is it will help us priortise your request.

Regards

Raj
Previous Topic: To get the name of the object(table/view) throwimg exception
Next Topic: problem with ref cursor
Goto Forum:
  


Current Time: Sat Dec 10 20:36:32 CST 2016

Total time taken to generate the page: 0.07907 seconds