Re: Retrieving just one store procedure

This should be easy.
Do import with show=y and all the ddl will be listed in the log file, with nothing imported to the database.
Then edit the log file and copy what you want.

Adar Yechiel
Rechovot, Israel

Harshan Vasudevan Eppurath wrote:
>
> Hello,
>
>
>
> I would like to know whether it is possible to retrieve just one
> stored procedure from an export. We are currently running 10.2.0.3.0.
>
>
>
> Cheers
>
> Harshan
>
>
>
> Harshan Eppurath
>
> Financial Services Strategic Business Unit
> Team: Basel II, Database Administrator BI Practice /
> Office: +91.40.2312.5000 / Extn: 28445 /Mobile: +919392426435/
> Fax: +91.40.2312.5002 / http://www.in.capgemini.com /
> <http://www.in.capgemini.com%20/> harshan.eppurath@capgemini.com
> <mailto:dorababu.kottapalli_at_capgemini.com>
> Kanbay, A Capgemini Group Company , #5, Software Units Layout |
> Madhapur|Hyderabad-81._ _
>
> **Together: the Collaborative Business Experience **
>
>
>
>
>
>
>
>
>
> This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is
> intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to
> read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message
> in error, please notify the sender immediately and delete all copies of this message.
>

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