-
Viewing a Procedure
Hi,
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....
-
-
The source of the mentioned procedure will be available at the
%oracle_home/rdbms/admin/spcpkg.sql
Using OEM/TOAD are some of the ways of extracting the source
-
Hi Thanks for info
I found the source in %oracle_home/rdbms/admin/spcpkg.sql
Thanks again
Shandy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|