ORA-19051 Cannot Use Fast Path Insert For This XMLType Table (Doc ID 1299774.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.5 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked as Top Hit on 10-NOV-2011
Checked for relevance on 02-Oct-2014


Goal

When trying to import a full export of a 10.2.0.2 database into a new 11.2.0.2 database it fails. The following query also fails on the new database:

select distinct (a.username) "USER", count (r.xmldata) "TOTAL"
from dba_users a, xdb.xdb$resource r
where sys_op_rawtonum (extractvalue (value(r),'/Resource/OwnerID/text()'))=a.USER_ID
group by a.username;

count (r.xmldata) "TOTAL" from dba_users a,
*
ERROR at line 2:
ORA-19051: Cannot use fast path insert for this XMLType table


Steps taken:

1. Create a new database in 11g R2 with just the structure
2. Take a full export from 10.2.0.2 database
3. Import into 11g R2 database

The new XML installation is showing as valid on the new machine:

SQL> SELECT COMP_NAME,VERSION,STATUS FROM DBA_REGISTRY WHERE COMP_NAME LIKE '%X%';

COMP_NAME
--------------------------------------------------------------------------------
VERSION STATUS
------------------------------ -----------
Oracle XDK
11.2.0.2.0 VALID

Oracle XML Database
11.2.0.2.0 VALID

Solution

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