Message-Id: <10736.126167@fatcity.com> From: "Mohan, Ross" Date: Tue, 9 Jan 2001 11:56:16 -0500 Subject: RE: batch recompile invalid packages This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07A5D.14DBCBF0 Content-Type: text/plain; charset="iso-8859-1" execute DBMS_UTILITY.COMPILE_SCHEMA(''); -----Original Message----- From: Armstead, Michael A [mailto:maa25681@GlaxoWellcome.com] Sent: Tuesday, January 09, 2001 10:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: batch recompile invalid packages I hope this question is as simple as it sounds. Try this: ALTER object-type object-name COMPILE; Hope this helps. Michael Armstead Database Administrator, OCP-Certified Corporate & Finance Information Systems Glaxo SmithKline > -----Original Message----- > From: John Dunn [SMTP:john.dunn@sefas.co.uk] > Sent: Tuesday, January 09, 2001 7:11 AM > To: Multiple recipients of list ORACLE-L > Subject: batch recompile invalid packages > > Is there a easy way for me to easily recompile all my packages, functions > for a user etc without doing a create/replace > > John > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Dunn > INET: john.dunn@sefas.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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: maa25681@GlaxoWellcome.com 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@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). ------_=_NextPart_001_01C07A5D.14DBCBF0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: batch recompile invalid packages

execute = DBMS_UTILITY.COMPILE_SCHEMA('<schemaname>');

-----Original Message-----
From: Armstead, Michael A [mailto:maa25681@GlaxoWellcome= .com]
Sent: Tuesday, January 09, 2001 10:41 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: batch recompile invalid packages


I hope this question is as simple as it sounds. Try = this:

ALTER object-type object-name COMPILE;

Hope this helps.

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline


> -----Original Message-----
> From: John Dunn = [SMTP:john.dunn@sefas.co.uk]
> Sent: Tuesday, January 09, 2001 7:11 AM
> To:   Multiple recipients of list = ORACLE-L
> Subject:      batch = recompile invalid packages
>
> Is there a easy way for me to easily recompile = all my packages, functions
> for a user etc  without doing a = create/replace
>
> John
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
>   INET: john.dunn@sefas.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@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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Armstead, Michael A
  INET: maa25681@GlaxoWellcome.com

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@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