My Oracle Support Banner

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 DECEMBER 31, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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