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

TNS-12160: TNS:internal error: Bad error number

1 Answers  


PLS-00651: implementation type in Aggregate/Table function should be a valid type

1 Answers  


ORA-33262: (DBERR01) Analytic workspace string does not exist.

1 Answers  


ORA-32306: updatable materialized views with user-defined types must use SELECT *

1 Answers  


ORA-06437: ssaio: the asynchronous write was unable to write to the database file.

1 Answers  






ORA-02141: invalid OFFLINE option

1 Answers  


PCB-00011: DBMS=V6 no longer supported; using DBMS=NATIVE

1 Answers  


PCB-00307: DROP TABLE statement is an Oracle extension

1 Answers  


LPX-00114: element "~1S" attribute "~2S" has invalid enumeration value "~3S"

1 Answers  


ORA-12316: syntax error in database link's connect string

1 Answers  


QSM-02116: mupltiple master sites

1 Answers  


NNL-00971: Query ID: number

1 Answers  


Categories