Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: [q] help!!! buffer_pool error (ora-25125)
Oracle has recognized this as a bug to 8.0.5.1 in the RDBMS(#803841) and has
come up with a working fix. I expect 8.0.5.2 to be out VERY soon. Nothing
like dynamic QA.
In article <36A70EF3.47B27FD9_at_lgtel.co.kr>,
kyutae lim <ktlim_at_lgtel.co.kr> 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:23 CST