Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: buffer_pool error (ora-25125)
I am quite sure this is a BUG in 8.0.5.1. (It works okay in 8.0.5.0). How
ironic after weeks awaiting for this latest patch set.
Why is it that Perfection is always only one release away??
In article <36A71311.2216084_at_capgemini.co.uk>,
Alex Hudghton <alex.hudghton_at_capgemini.co.uk> wrote:
> Not sure this is the answer, but don't you need to set 'NEXT' value ???
>
> Alex
>
> kyutae lim wrote:
>
> > hi, there.
> >
> > when I create a following table, I met ora-25125 error.
> > this error is related 'buffer_pool'. But I don't understand
> > this error messgage. I think this 'buffer_pool' command is correct
> > in Oracle 8.0.5.1.
> > Please help me as soon as possible.
> > thank you.
> >
> > my oracle env:
> > version : oracle 8.0.5.1
> > os : hpos 11.0
> >
> > CREATE TABLE table_name (col_1 number, col_2 number)
> > PARTITION BY RANGE (col_1)
> > (PARTITION ONE VALUES LE 3 SS THAN (10)
> > STORAGE (INITIAL 10k BUFFER_POOL RECYCLE),
> > PARTITION TWO VALUES LESS THAN (20) STORAGE (BUFFER_POOL KEEP));
> > STORAGE (INITIAL 10k BUFFER_POOL RECYCLE),
> > *
> > ERROR at line 4:
> > ORA-25125: BUFFER_POOL storage option not allowed
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 23 1999 - 01:47:25 CST