RE: Invalid objects

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

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>=20

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

Received on Wed Oct 18 2000 - 13:18:06 CDT