RE: Invalid objects

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Wed, 18 Oct 2000 15:39:40 -0300
Message-Id: <10653.119691@fatcity.com>

I think Oracle maintains that invalid objects are recompiled = automatically
when first accessed.

If they aren't recompiling, there are probably things to fix in the = code.

Recompiling them manually avoids that time delay a user will experience while packages, etc. are recompiling.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

	-----Original Message-----
	From:	Boivin, Patrice J=20
	Sent:	Wednesday, October 18, 2000 3:18 PM
	To:	'ORACLE-L_at_fatcity.com'
	Subject:	RE: Invalid objects

	Sometimes you have to run this as the owner of those objects, if the

code doesn't explicitly specify schemas before table names, am I wrong?

	Patrice Boivin
	Systems Analyst (Oracle Certified DBA)

	Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
	Technology Services        | Services technologiques
	Informatics Branch         | Direction de l'informatique=20
	Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

	E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>


		-----Original Message-----
		From:	Ruth Gramolini [SMTP:rgramolini_at_tax.state.vt.us]
		Sent:	Wednesday, October 18, 2000 3:50 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Re: Invalid objects

		select 'alter '||object_type||'
'||owner||'.'||object_name||' compile;' from
		dba_objects where status =3D'INVALID';

		Spool the output of this query ( or cut and paste) and run
it.  It will
		compile all invalid objects if there are no other problems.

		HTH,
		Ruth
		----- Original Message -----
		To: "Multiple recipients of list ORACLE-L"
<ORACLE-L_at_fatcity.com>
		Sent: Wednesday, October 18, 2000 1:55 PM




		>

		> How can you fix invalid stored procedures?

		>

		> -----

		> Sent using MailStart.com (

http://MailStart.Com/welcome.html )


		> The FREE way to access your mailbox via any web browser,

anywhere!


		>

		> --

		> Please see the official ORACLE-L FAQ:

http://www.orafaq.com


		> --

		> Author:

		>   INET: cemail_at_sprintmail.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_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).

		--=20
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		--=20
		Author: Ruth Gramolini
		  INET: rgramolini_at_tax.state.vt.us

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists
=09

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).

Received on Wed Oct 18 2000 - 13:39:40 CDT