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.