Re: Invalid Objects (packages, triggers, etc...)

From: Shujda <nlalovic_at_comcast.net>
Date: Wed, 19 Feb 2003 00:16:07 -0500
Message-ID: <FZqcnS1fU4uwjs6jXTWcqQ@comcast.com>

dbms_utility.compile_schema('schema_name'); compiles all objects owned by the schema_name.

"Ron" <southbayguy_at_linkline.com> wrote in message news:gop55v8c6shj70i8no4iq77n4d82c0op0i_at_4ax.com...
> Help
>
> I'm looking for a script that will recompile all invalid Oracle
> objects (triggers, packages, views, etc..). I'm running Oracle on a
> UNIX platform.
>
> Thanks in advance.
>
> Ron (southbayguy_at_linkline.com)
>
Received on Tue Feb 18 2003 - 23:16:07 CST

This message: [ Message body ]
Next message: Paul Drake: "Re: Use of raw partition for the oracle tablespace"
Previous message: Kurt Harless: "Oracle 9.2 / RH Linux 7.2 / JRE not found on install"
In reply to: Ron: "Invalid Objects (packages, triggers, etc...)"
Next in thread: SoulSurvivor: "Re: Invalid Objects (packages, triggers, etc...)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US