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

NNL-00802: Queries received, type ADDRESS: number

1 Answers  


PLS-00120: inappropriate argument in OPEN statement

1 Answers  


ORA-00022: invalid session ID; access denied

1 Answers  


NZE-29176: CRL signature verification failed

1 Answers  


ORA-17504: ksfddel:Failed to delete file string

1 Answers  


QSM-01111: no partition key or partition marker found in MV, string

1 Answers  


PLS-00422: no PL/SQL translation for the bindtype given for this bind variable

1 Answers  


RMAN-06159: error while looking up backup set

1 Answers  


ORA-16636: the object is permanently disabled

1 Answers  


ORA-13516: SWRF Operation failed: string

1 Answers  


SQL*Loader-00704: Internal error: string [number]

1 Answers  


DRG-10854: Invalid scoring algorithm string specified for query template

1 Answers  


Categories