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



ORA-31165: 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 either
contains an out-of-line partitioned table or the table
itself is partitioned by one of the attributes of xmltype.
This type of table 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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NZE-29112: Cannot access attributes from a PKCS #12 certificate bag.

1 Answers  


ORA-08233: smsdes: cannot unmap SGA

2 Answers  


PCB-00306: CREATE FUNCTION/PROCEDURE/PACKAGE/TRIGGER are Oracle extensions

1 Answers  


TNS-00081: * trace_on - ask process name to turn tracing on

1 Answers  


NZE-29016: inadequate PKCS1 message padding

1 Answers  






ORA-24170: %s.string is created by AQ, cannot be dropped directly

1 Answers  


ORA-12800: system appears too busy for parallel query execution

1 Answers  


ORA-29895: duplicate base datatype specified

1 Answers  


QSM-02048: outer join in mv

1 Answers  


ORA-14161: subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-31413: change set string is currently being advanced

1 Answers  


ORA-23483: object "string"."string" not allowed in this operation.

1 Answers  


Categories