After Schema Registration W/GENTABLES=>True, Table Creation W/O-R Storage=ORA-19046
Last updated on NOVEMBER 19, 2012
Applies to:Oracle Server - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
After successful schema registration with GENTABLES=>TRUE (i.e. the default value), table creation with Object-Relational (O-R) storage including:
XMLTYPE COLUMN <ColumnName> STORE AS OBJECT RELATIONAL
fails with this error:
ERROR at line 1:
ORA-19046: Out-of-line table cannot be shared by two top-level tables.
(Note: These same steps work in 188.8.131.52.0.)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms