Dear All:
My oracle version is Oracle9.2.0.8
SQL> alter system set shared_pool_size=85000000 scope=both;
alter system set shared_pool_size=85000000 scope=both
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is
invalid
ORA-04033: Insufficient memory to grow pool




-----Original Message-----
From: RAMTeCH Azad [mailto:[Email address protected]
Sent: Wednesday, March 05, 2008 5:24 PM
To: Yonglong Li/WKS/Wistron
Subject: Re: I give up (dynamic plsql)

**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Step 1. login through sysdba and check the shared pool size :-->
SQL>show
parameter shared_pool_size; (this will show the current shared_pool_size
value)
Step 2. SQL>Alter system set shared_pool_size=<new value in KB or MB>
scope=spfile;


Azad


----- Original Message -----
From: "YONGLONG_LI"
[Email address protected]
To: "LazyDBA Discussion" [Email address protected]
Sent: Wednesday, March 05, 2008 2:34 PM
Subject: RE: I give up (dynamic plsql)


> Dear All:
> How can I increase the value of shared_pool_size online?
>
> -----Original Message-----
> From: kazi
> [mailto:oracledba-ezmlmshield-x47754945.[Email address protected]
> Sent: Wednesday, March 05, 2008 5:02 PM
> To: LazyDBA Discussion
> Subject: Re: I give up (dynamic plsql)
>
> Why dynamic sql? It is more complicated and slower!
>
> I would use sometthing like :
>
> dat date;
> ...
> dat := '06-02-2007';
> LOOP
> ...
> INSERT INTO scott.emp_test SELECT * FROM scott.emp WHERE
a.hiredate
> < sysdate+1;
> ...
> dat := dat+1;
> EXIT WHEN dat > '02-02-2008' ;
> END LOOP;
>
> Well I don't see a point of "day by day" if tha day is not envolved in
> your transaction.
> Or maybe you replace "< sysdate+1" with "= dat"
>
> KAzi
>
> ab265 wrote:
> > Experts,
> >
> > For god sake help me doing that. I am trying to insert date
from
> table to
> > table depending on specific date. I want to do the following:
> >
> > 1- select date from 06-02-2007 day by day to 02-02-2008.
> > 2- insert into another table day by day (one by one).
> >
> > Best result i am looking for is a statement like the one below. It
> didn't work
> > actually. I have been trying for a long time. I need to supstitue
> sysdate in the
> > code withe specific date like 06-02-2007.
> >
> > I want this dynamic sql to run. For god sake, help me.
> >
> > select 'INSERT INTO scott.emp_test SELECT * '|| FROM scott.emp || '
> WHERE
> > a.hiredate' ||' ' < ' || sysdate + 1 ;
> >
> > Thanks,
> >
> >
> >
> >
> >
---------------------------------------------------------------------
> > 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