Re: Procedure Storage/Analyze Question

Barbara Hiles wrote:
>
> Where do these get stored? Is there a table I can list to see what is out
> there?
> Specifically, I am trying to execute dbms_utility.analyze_schema. I get
> unable to open file.
> Does this mean it's not loaded? Or does it mean something else?
> I'm in sqlplus trying to do a start on this - is that right?
> Do I sound confused? (I am)

If you are doing this sor of thing for the first time, use the SQL*Plus command directly - ANALYZE. The dbms_* procuedures work within a PL/SQL block and permit you to 'program' further things into your work.

Use the ANALYZE command, get to know how it works and what it does for you and where it puts what information. Then you can move on to pl/sql programs if you *need* to.

-- 
R. Wayne Linton, I.S.P.
Database & Systems Management
Shell Canada Ltd.