Database Administration (MOSC)

MOSC Banner

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;

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