ORA-29384: number of children for plan string exceeds string

Cause : An attemptw as mdae toc reat eor mdoify hte spceifie dplan ,but hte plna hasm ore htan 3 2chilrden.

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

Makes ure hte spceifie dplanp oint sto n omoret han 23 disitnct ondes.

update : 23-06-2017
ORA-29384

ORA-29384 - number of children for plan string exceeds string
ORA-29384 - number of children for plan string exceeds string

  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • ora-12452 : label tag string already exists
  • ora-37171 : dimension sources not specified
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-39003 : unable to get count of total workers alive
  • ora-07710 : sksaprs: file name buffer too small
  • ora-01622 : thread number must be specified - default not specific
  • ora-00202 : control file: 'string'
  • ora-32695 : HTI: Not enough memory
  • ora-21707 : pin duration is longer than allocation duration
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-26513 : push error: master proc. string$RP.string failed for trans:string seq:string
  • ora-36765 : (XSAGGCNTMOVE03) A string aggregation variable cannot have a string AGGCOUNT.
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-19562 : file string is empty
  • ora-30752 : column or table string is not substitutable
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-21604 : property [string] is not a property of transient or value instances
  • ora-13340 : a point geometry has more than one coordinate
  • ora-10577 : Can not invoke test recovery for managed standby database recovery
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-02702 : osnoraenv: error translating orapop image name
  • ora-23421 : job number string is not a job in the job queue
  • ora-27415 : repeat interval or calendar must start with the FREQ= clause
  • ora-10973 : backout evet for 2619509
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-12096 : error in materialized view log on "string"."string"
  • 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.