Re: How Compile all the objects

Hi Sandy,

Try to use sys.dbms_utility.compile_schema procedure:

  procedure compile_schema(schema varchar2);

• Compile all procedures, functions and packages in the specified
• schema. After calling this procedure you should select from view
• ALL_OBJECTS for items with status of 'INVALID' to see if all objects
• were successfully compiled. You may use the SQLDBA command "SHOW
• ERRORS <type> <schema>.<name>" to see the errors assocated with
• 'INVALID' objects.
• Input arguments:
• schema
• Name of the schema.
• Exceptions:
• ORA-20000: Insufficient privileges for some object in this schema.

But remember to use capital letters for schema name...

Hope that helps.

Sandy wrote:
>
> Hi,
>
> I would like to compile all the objects of the database at
> the same time. I made a procedure doing this and using the
> procedure "dbms_ddl.alter_compile" with the parameters
> type_object,owner and name_object I took in the all_objects
> tablespace. I created it under the user sys and when i
> execute it with exec procedure_name it said it has succeded
> without doing nothing. I would like to know why it doesn't
> work or if there is another way to do it with the schema
> manager for example .
>
> Thanks
>
> Sandy

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru