Dear LazyDBA:
We encounter this error:
ORA-04031: unable to allocate 4224 bytes of shared memory
("shared_pool","unknown object","MTTR advisory","MTTR advisory")
DBW0: terminating instance due to error 4031

Pls give us your hands! Thanks!


-----Original Message-----
From: Jayadevan M
[mailto:oracledba-ezmlmshield-x40924279.[Email address protected]
Sent: Thursday, February 28, 2008 2:42 PM
To: LazyDBA Discussion
Subject: RE: Re-compile invalid objects in oracle9i

Hi,
May be you have blank lines in the sql? Either delete them or set
sqlblanklines on
try
show sqlblanklines

Regards,
Jayadevan



"SriRagava
Srinivasarao k
" To
<oracledba-ezml "LazyDBA Discussion"
mshield-x727239 <[Email address protected]

28.[Email Address Removed] cc
LazyDBA.com>
Subject
02/28/2008 RE: Re-compile invalid objects
11:45 AM in oracle9i










Check privileges

Your syntax is correct the same syntax working in my place.


-----Original Message-----
From: Amit
[mailto:oracledba-ezmlmshield-x50703602.[Email address protected]
Sent: Thursday, February 28, 2008 11:07 AM
To: LazyDBA Discussion
Subject: Re-compile invalid objects in oracle9i

Dear All,

I have to alter a table in production database. Then associated
objects
become invalid. So I want to rebuild by using below script:

spool on

Spool D:\amit\CalendarRegistration\ForRelease\SpoolText.txt

select

'ALTER ' || OBJECT_TYPE || ' ' ||

OWNER || '.' || OBJECT_NAME || ' COMPILE;'

from

all_objects

where

status = 'INVALID'

and

object_type in ('PACKAGE','FUNCTION','PROCEDURE')

;


but it is giving error like
SP2-0734: unknown command beginning "'ALTER ' |..." - rest of line
ignored.
SP2-0734: unknown command beginning "OWNER || '..." - rest of line
ignored.
SP2-0042: unknown command "from" - rest of line ignored.
SP2-0734: unknown command beginning "all_object..." - rest of line
ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SP2-0042: unknown command "where" - rest of line ignored.
SP2-0734: unknown command beginning "status = '..." - rest of line
ignored.
SP2-0042: unknown command "and" - rest of line ignored.
SP2-0734: unknown command beginning "object_typ..." - rest of line
ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.



Please help me on this issue.

Thanks,
Amit



This e-mail is confidential and may be legally privileged. If you are
not the intended recipient, please notify the sender immediately and
delete this e-mail.

????????????????????????????????????????????????????????????????????????

?????????????????????????????????????????????


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html








---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page