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

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
Received on Thu Jan 21 1999 - 05:44:18 CST