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

I've just cut the SQL from your post (changing only the 'LE 3 SS') and run it on 8.0.4.0 on hp-ux 10.20, and it works as expected - checked by looking at the buffer_pool column of user_tab_partitions.

Does the same error occur on non-partitioned tables ? Can you create the table and then:

alter table table_name modify partition one storage (buffer_pool keep);

Silly question, and it shouldn't make any difference anyway, have you actually allocated blocks to the KEEP and RECYCLE pools ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

kyutae lim wrote in message <36A70EF3.47B27FD9_at_lgtel.co.kr>...
>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 - 06:39:20 CST