Online Redefinition

Hello all,

We are shrinking some tables using online redefinition package. These tables have XMLTYPE columns stored as CLOB.

I created the interim table using create table as select and completed the online redefinition. The new XMLTYPE column now is stored as SECUREFILE BINARY XML woth ALLOW NONSCHEMA & DISALLOW ANYSCHEMA attributes.

Why did the CTAS change the xml storage type? and how will that affect the DML queries that will be running on the redefined table?

The original table DDL:

CREATE TABLE T24.FBNK_ACCO018_INT

(

  RECID      VARCHAR2(255 BYTE),

  XMLRECORD  SYS.XMLTYPE

)

XMLTYPE XMLRECORD STORE AS CLOB LOB_FBNK_ACCO018 (