ORA-29915: cannot select FOR UPDATE from collection operand

Cause : Colletcion oeprandsc annotb e updtaed

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Remov eFOR UDPATE caluse

update : 17-08-2017
ORA-29915

ORA-29915 - cannot select FOR UPDATE from collection operand
ORA-29915 - cannot select FOR UPDATE from collection operand

  • ora-36161 : (XSAGGRRUVCV) Aggregation variable workspace object cannot have itself as a COUNTVAR.
  • ora-01263 : Name given for file destination directory is invalid
  • ora-24166 : evaluation context string.string has errors
  • ora-33048 : (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.
  • ora-00030 : User session ID does not exist.
  • ora-36646 : (XSDUNION08) Only concat dimensions can be redefined as UNIQUE. workspace object is not a concat dimension.
  • ora-00287 : specified change number string not found in thread string
  • ora-00972 : identifier is too long
  • ora-29500 : NAMED keyword is invalid in CREATE JAVA CLASS
  • ora-21606 : can not free this object
  • ora-40202 : column string does not exist in the input table string
  • ora-12488 : maximum label does not dominate minimum label
  • ora-14408 : partitioned index contains subpartitions in a different tablespace
  • ora-13372 : failure in modifying metadata for a table with spatial index
  • ora-19122 : unsupported XQuery declaration
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-13634 : The task string needs to be reset before being re-executed.
  • ora-39061 : import mode string conflicts with export mode string
  • ora-02077 : selects of long columns must be from co-located tables
  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-12708 : error while loading create database NLS parameter string
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-38704 : Checksum error in flashback database log file header.
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-00072 : process "string" is not active
  • ora-29918 : cannot create domain indexes on temporary tables
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-16788 : unable to set one or more database configuration property values
  • ora-14404 : partitioned table contains partitions in a different tablespace
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.