You may need to increase your shared pool .
Regards,
Hrishikesh Vaidya.
-----Original Message-----
From: YONGLONG_LI [mailto:oracledba-ezmlmshield-x13619740.[Email address protected]
Sent: Thursday, February 28, 2008 12:48 PM
To: LazyDBA Discussion
Subject: RE: Re-compile invalid objects in oracle9i
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
---------------------------------------------------------------------
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
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Oracle LazyDBA home page