High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

ORA-14466: Data in a read-only partition or subpartition cannot be modified. ORA-02063: preceding li

When I am trying to insert data using sequence in SHARDED table , sometimes I am getting (seems it depends on the value) the following error:

SQL> insert into BOOKS values(BOOKID_SEQ.nextval,'My Second Book','MyName', 'MySurname');

insert into BOOKS values(BOOKID_SEQ.nextval,'My Second Book','MyName', 'MySurname')

*

ERROR at line 1:

ORA-14466: Data in a read-only partition or subpartition cannot be modified.

ORA-02063: preceding line from ORA_SHARD_POOL@ORA_MULTI_TARGET

If i use literals, it is always OK:

SQL> insert into BOOKS values(99,'My Second Book','MyName', 'MySurname');

1 row created.

I think it is a bug of SDBs, do you have any idea?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center