OraFAQ Forum: Server Utilities » how to import procedure

Home » RDBMS Server » Server Utilities » how to import procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to import procedure [message #70533]

Wed, 26 June 2002 19:27

llz
Messages: 14
Registered: June 2002

Junior Member

How to only import procedure of a dmp file to Oracle User but data

Report message to a moderator

Re: how to import procedure [message #70535 is a reply to message #70533]

Wed, 26 June 2002 20:36

manish mendiratta
Messages: 110
Registered: May 2002

Senior Member

I am not sure about this...but what you can do is
import the scheme in which the procedure lies and import with rows=n for table. This way you can import the procedure and tables w/o data.

HTH.

MM.

Report message to a moderator

Re: how to import procedure [message #70537 is a reply to message #70535]

Wed, 26 June 2002 21:47

llz
Messages: 14
Registered: June 2002

Junior Member

Thanks your answer but I am sorry I can't finish this import after 30 minutes.
Whether or no I thank you very much!

Report message to a moderator

Re: how to import procedure [message #70542 is a reply to message #70533]

Thu, 27 June 2002 06:28

Grant
Messages: 578
Registered: January 2002

Senior Member

Do an export with ROWS=N and an import with SHOW=Y LOG=logfilename. This will give you an ascii file and you can extract the procedures or whatever object you need and run it in the new schema. Do a "exp help=y or imp help=y".

Report message to a moderator

Re: how to import procedure [message #70549 is a reply to message #70542]

Thu, 27 June 2002 18:24

llz
Messages: 14
Registered: June 2002

Junior Member

this way is good , thanks!

Report message to a moderator

Previous Topic:	Re: Export/import only those tables that contain data
Next Topic:	sql plus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 16:59:28 CDT 2024