ORA-31164: cannot load object-relational XML attribute using
direct path



ORA-31164: cannot load object-relational XML attribute using direct path..

Answer / guest

Cause: The table being loaded contains a xml column with
object-relational storage. The xmltype column contains a
type with subtypes. This type of attribute cannot be loaded
with direct path.

Action: Perform the load with conventional path mode.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-00372: file string cannot be modified at this time

1 Answers  


ORA-00273: media recovery of direct load data that was not logged

1 Answers  


ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION

1 Answers  


NNL-00855: Slowest rename processing time: string

1 Answers  


DRG-10702: cannot create or modify preference in another user's schema

1 Answers  






ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

1 Answers  


PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 Answers  


ORA-22322: error table "string"."string" has incorrect structure

1 Answers  


ORA-24129: table name string does not start with string prefix

1 Answers  


PLS-00393: wrong number of columns in SELECT...INTO statement

1 Answers  


ORA-24029: operation not allowed on a single-consumer queue

1 Answers  


Categories