Sybrand Bakker wrote:
> On Thu, 11 Dec 2003 19:10:13 GMT, "Francesco Martelli"
> <mortecerta_NOSPAM__at_libero.it> wrote:
>
>
>>Hallo all,
>>someone knows a script to compile all the procedure in a schema, in order,
>>making attention at the dependencies?
>>
>>I need it because I'm doing an util application which it supplies help to my
>>company staff to install and manage ours products.
>>
>>I'm using Oracle 8 and 9i
>>
>>Thanks very much in advance,
>>
>>Davide
>>
>
>
> dbms_utility.compile_schema('<schemaname>')
> to compile all invalid objects use $ORACLE_HOME/rdbms/admin/ultrp.sql
> connected as internal
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
utl_recomp.recomp_serial can also be used to compile schema's and is
a lot faster than dbms_utility.compile_schema, or so it seems
--
Regards, Frank van Bortel
Received on Thu Dec 11 2003 - 15:55:19 CST
