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

RMAN-06192: maximum value for MAXPIECESIZE or MAXSETSIZE must be between 1 Kb and 2048 Gb

1 Answers  


ORA-32027: There is no string column with the matching type in string.string.

1 Answers  


SQL*Loader-00468: OID directive expects 1 argument, number found.

1 Answers  


ORA-19751: could not create the change tracking file

1 Answers  


NNL-00580: register_ns: <name server> <address> <domain>

1 Answers  


ORA-08175: discrete transaction restriction violated (string)

1 Answers  


ORA-30043: Invalid value 'string' specified for parameter 'Undo_Management'

1 Answers  


NNC-00419: authoritative server is unreachable

1 Answers  


NNL-01050: Version banner is "string"

1 Answers  


ORA-06448: ssvpstp: Failed with unexpected error number.

1 Answers  


ORA-09934: Link of current password file to old failed.

1 Answers  


SQL*Loader-00527: OCI return status: no data

1 Answers  


Categories