Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Modify XMLTYPE column from "STORE AS CLOB" to "STORE AS SECUREFILE BINARY XML"

pcpaascheJan 8 2015 — edited Jan 8 2015
select * from v$version;


Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


PL/SQL Release 11.2.0.4.0 - Production


CORE 11.2.0.4.0 Production


TNS for Linux: Version 11.2.0.4.0 - Production


NLSRTL Version 11.2.0.4.0 - Production




CREATE TABLE imp_xml_table (c1 XMLTYPE) XMLTYPE c1 STORE AS CLOB;




ALTER TABLE imp_xml_table MODIFY (c1 ) XMLTYPE c1 STORE AS SECUREFILE BINARY XML;


Table altered.

I have a table with an column with datatype XMLTYPE stored as CLOB. I need to change this column to XMLTYPE stored as SECUREFILE BINARY XML.

Using the create table and alter table statements above, Oracle reports the column as having been changed by the altered statement. However, when checking, the storage is still CLOB.

How to I change the storage option for my XMLTYPE column?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2015
Added on Jan 8 2015
1 comment
2,626 views