Database Administration (MOSC)

MOSC Banner

trying to compress a lob basicfile of a partiton and getting following errors ORA-43856: Unsupported

edited Dec 27, 2018 5:02PM in Database Administration (MOSC) 4 commentsAnswered

trying to compress a lob basicfile of a partiton and getting following errors ORA-43856: Unsupported LOB type for SECUREFILE LOB operation

SEGMENT_NAME            PARTITION_NAME                              SEGMENT_TYPE       SEGMENT_SU

------------------------------      ------------------------------                         ------------------                ----------

XXX_ENH_SEG                 XXX_ENH_JUL2018_SEG                   LOB PARTITION          ASSM

tried issuing

when creating the partition the following command was issued (Similar)

alter table XXX.XXXXXX add partition XXX_JUL2018 VALUES LESS THAN (TO_DATE('08-01-2018','MM-DD-YYYY')) tablespace XXX_TS_JUL2018 storage(pctincrease 0) LOB (XXX_XML) store as XXX_ENH_JUL2018_SEG (TABLESPACE XXX_TS_JUL2018);

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