After deletion of records Can Binary Xml Type storge releases space automatically
Oracle 19c = 19.18
For example if i deleted record from BINARY XML type storage, will the space reclaimed automatically ?
Table created
CREATE TABLE "ABC123"."TMP1"
( "RECID" VARCHAR2(255 BYTE) NOT NULL ENABLE,
"XMLRECORD" "SYS"."XMLTYPE") SEGMENT CREATION IMMEDIATE
PCTFREE 20 PCTUSED 40 INITRANS 100 MAXTRANS 255
NOCOMPRESS LOGGING TABLESPACE "XYZ123"
XMLTYPE COLUMN "XMLRECORD" STORE AS SECUREFILE BINARY XML (
TABLESPACE "XYZ123" ENABLE STORAGE IN ROW CHUNK 8192
CACHE NOCOMPRESS KEEP_DUPLICATES) ALLOW NONSCHEMA DISALLOW ANYSCHEMA PARTITION BY HASH (RECID) PARTITIONS 64;