Database Administration (MOSC)

MOSC Banner

Change xmltype column to nologging

edited Jul 27, 2024 10:49AM in Database Administration (MOSC) 8 commentsAnswered ✓

I am using 19c database. currently xmltype column is logging

DDL:
CREATE TABLE MDATA
(
FILINGID NUMBER C
IDENTIFYINGINFO SYS.XMLTYPE
)
XMLTYPE IDENTIFYINGINFO STORE AS SECUREFILE BINARY XML (
TABLESPACE LOB_03
ENABLE STORAGE IN ROW
CHUNK 16384
NOCACHE
LOGGING
STORAGE (
INITIAL 208K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
));

I want to change the IDENTIFYINGINFO column to nologging.

I tried following but did not work. Any idea?

alter table MDATA modify lob (IDENTIFYINGINFO)(nocache nologging)
ORA-00904: "IDENTIFYINGINFO": invalid identifier

alter table MDATA modify (IDENTIFYINGINFO xmltype) nocache nologging
ORA-22859: invalid modification of columns

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