ORA-08103: Object No Longer Exists When Inserting Into A New Partition With Is Json Constraint In Place (Doc ID 2687165.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 19.3.0.0.0 version, XML Database

When attempting inserting into a new partition with is json constraint in place
the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-08103: object no longer exists

CREATE TABLE JSON_TEST(
id VARCHAR2(47) NOT NULL,
data BLOB NOT NULL,
created DATE,
CONSTRAINT chk_data_json CHECK (data IS JSON),
CONSTRAINT pk_json_test PRIMARY KEY (id) USING INDEX TABLESPACE
FUL_INDEX_AUTO_01
)
LOB (data) STORE AS SECUREFILE data_SEG
(TABLESPACE FUL_DATA_AUTO_01
RETENTION AUTO
CACHE
LOGGING)
TABLESPACE FUL_DATA_AUTO_01
PARTITION BY RANGE(created) INTERVAL( NUMTODSINTERVAL(1,'DAY'))
STORE IN (FUL_DATA_AUTO_01)
(
PARTITION P1 VALUES LESS THAN (TO_DATE('2020-01-01', 'YYYY-MM-DD'))
TABLESPACE FUL_DATA_AUTO_01
)
;

Then insert a large JSON document

The insert creates the daily partition but the insert fails (ORA-08103: object no longer exists).

The partition in created so subsequent runs work.

If the IS JSON constraint is removed the insert works

Also, if the JSON document is small the insert works with the IS JSON constraint

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.