The utlrp.sql script is a good alternative (its
nothing special, its just keeps on going until
everything's done)
hth
connor
- Kathy Duret <KathyD_at_belkin.com> wrote: > Package
bodies, procedures, function in packages
> need to be compiled before packages.
> DBMS_UTILITY.compile_schema
> I believe compiles in Alphabetically order not in
> functional order.
>
> Kathy
>
> -----Original Message-----
> Sent: Wednesday, September 12, 2001 10:11 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Is there something wrong with
> dbms_utility.compile_schema . When I tried to use it
> , I left with few invalid objects . But if I
> manually compile those objects using alter package
> *** . they get compiled .
> Any Idea why ?
>
> BIgP
>
>
>
> Confidential
> This e-mail and any files transmitted with it are
> the property
> of Belkin Components and/or its affiliates, are
> confidential,
> and are intended solely for the use of the
> individual or
> entity to whom this e-mail is addressed. If you are
> not one
> of the named recipients or otherwise have reason to
> believe
> that you have received this e-mail in error, please
> notify the
> sender and delete this message immediately from your
> computer.
> Any other use, retention, dissemination, forwarding,
> printing
> or copying of this e-mail is strictly prohibited.
>
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Get your free @yahoo.co.uk address at
http://mail.yahoo.co.uk
or your free @yahoo.ie address at
http://mail.yahoo.ie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 12 2001 - 16:50:07 CDT
