I was wondering if anyone could tell me how i can get a copy of a procedure i.e.
I want a copy of the procedure STATSPACK.STAT_CHANGES
I have queried ALL_SOURCE but cant work out how to specifically select the STAT_CHANGES part so I can spool and save it to a file.
Any advice much appreciated....
05-12-2005, 09:11 AM
how about try dba_source
05-12-2005, 09:14 AM
The source of the mentioned procedure will be available at the
Using OEM/TOAD are some of the ways of extracting the source
05-12-2005, 09:40 AM
Hi Thanks for info
I found the source in %oracle_home/rdbms/admin/spcpkg.sql