Unable To Create Binary XML Table As Non SYS User in Version 11.2 With Compatible 10.2.0.3
Last updated on JULY 27, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
While creating binary xml table as non sys user failed with following errors:
create table aa ( x xmltype) XMLTYPE COLUMN x store as binary xml
ERROR at line 1:
ORA-00406: COMPATIBLE parameter needs to be 18.104.22.168.0 or greater
ORA-00722: Feature "Binary XML"
But as sys user, we are able to create tables stored as binary xml.
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