ORA-29917: cannot lock a table which gets its rows from a
collection operand



ORA-29917: cannot lock a table which gets its rows from a collection operand..

Answer / guest

Cause: Tables which gets its rows from a collection operand
cannot be locked

Action: Don't lock the table

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06262: NETNTT: nfconn() failed

1 Answers  


AUD-00803: internal error while processing WHERE clause

1 Answers  


PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


CLSS-02205: remote node string signaled our eviction via voting device: cause string

1 Answers  


ORA-14605: Name missing for subpartition / lob segment in template

1 Answers  






RMAN-20222: datafilename not found in recovery catalog or is ambiguous

1 Answers  


ORA-15120: ASM file name 'string' does not begin with the ASM prefix character

1 Answers  


ORA-00333: redo log read error block string count string

1 Answers  


ORA-38957: Target database not 10.0.0.0 compatible

1 Answers  


ORA-28661: Object already has COMPRESS clause specified

1 Answers  


IMP-00021: INCTYPE parameter is obsolete

1 Answers  


ORA-12480: specified clearance labels not within the effective clearance

1 Answers  


Categories