Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [q] help!!! buffer_pool error (ora-25125)

Re: [q] help!!! buffer_pool error (ora-25125)

From: <mikemost_at_my-dejanews.com>
Date: Sat, 23 Jan 1999 07:47:23 GMT
Message-ID: <78buqa$g3g$1@nnrp1.dejanews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US