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

ORA-16801: Some log transport related property is inconsistent.

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


EXP-00045: Cannot export SYSTEM Tablespace for Point-in-time Recovery or Transportable Tablespace

1 Answers  


NNO-00071: cannot construct cache checkpoint file name

1 Answers  


PCC-02394: Input file name and output filename are identical

1 Answers  






ORA-08008: another instance is mounted with USE_ROW_ENQUEUES = string

1 Answers  


DRG-11817: Proxy Redirect

1 Answers  


LCD-00201: could not open specified filename [string]

1 Answers  


ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

2 Answers  


ORA-25453: invalid iterator: string

1 Answers  


QSM-02038: Partition Change Tracking (PCT) is enabled

1 Answers  


RMAN-06571: datafile number does not have recoverable copy

1 Answers  


Categories