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?