Re: Multiple packages compilation

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Wed, 09 Jan 2002 19:31:41 +0100
Message-ID: <j23p3uks5ap467jehnpihr9nnpg9jk17ol@4ax.com>

On Wed, 9 Jan 2002 09:24:28 +0100, "Patrick J." <patrickREMOVE.jTHIS_at_kneip.com> wrote:

>Hi,
>
>To set-up a new Oracle application (8.1.7) on a production server, I have to
>compile about 110 packages which are interdependent. There are even cases
>where package A uses package B, and package B uses package A.
>
>What is the better solution to compile all these packages in an automated
>way, and obtain all the packages with a 'valid' status?
>Should I first compile the spec part of every package, and then the bodies?
>Other ideas?
>
>Thanks,
>
>Patrick J.
>

use dbms_utility.compile_schema('<OWNER>') if they are in one schema.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 09 2002 - 12:31:41 CST