Re: How do I transfer stored procedures between databases

Douglas C. Hay wrote:
>
> Is there any way to export/import only the stored procedures for a specific
> user.

  You can export the stored procedures by using Procedure Builder. Alternatively, you can write a script to extract the texts of the stored procedures to a text file by querying user_source.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841