Very Computer

by **kyutae li** » Fri, 22 Jan 1999 04:00:00

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

by **Alex Hudghto** » Fri, 22 Jan 1999 04:00:00

Not sure this is the answer, but don't you need to set 'NEXT' value ???

Alex

> 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

by **Jonathan Lewi** » Fri, 22 Jan 1999 04:00:00

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

>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

Very Computer

help!!! buffer_pool error (ora-25125)

help!!! buffer_pool error (ora-25125)

help!!! buffer_pool error (ora-25125)

help!!! buffer_pool error (ora-25125)