How to import only stored procedure?


I've exported an entire database (v7.3), how can I import nothing but
stored procedures? I haven't found any suitable option of IMP, if I
imported everything into an other instance, I could print stored
procedures from ALL_SOURCE with DBMS_OUTPUT but it is not an efficient
way.


Ans:
I have a script that filters DDL out of an export/import file.

URL:   http://www.tc.umn.edu/~hause011

ugly_DDL is the script name.
 

Hosted by www.Geocities.ws

1