Unable To Create Binary XML Table As Non SYS User in Version 11.2 With Compatible 10.2.0.3 (Doc ID 1559286.1)

Last updated on JULY 27, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

While creating binary xml table as non sys user failed with following errors:

SQL> create table aa ( x xmltype) XMLTYPE COLUMN x store as binary xml;
create table aa ( x xmltype) XMLTYPE COLUMN x store as binary xml
*
ERROR at line 1:
ORA-00406: COMPATIBLE parameter needs to be 11.0.0.0.0 or greater
ORA-00722: Feature "Binary XML"

 But as sys user, we are able to create tables stored as binary xml.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms