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-04-2017
ORA-29384

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

  • ora-01720 : grant option does not exist for 'string.string'
  • ora-19321 : Could not open HTTP connection to host (string): port (string)
  • ora-22292 : Cannot open a LOB in read-write mode without a transaction
  • ora-28049 : the password has expired
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-28272 : Domain policy restricts password based GLOBAL user authentication.
  • ora-26670 : STREAMS option requires COMPATIBLE parameter to be string or higher
  • ora-01577 : cannot add log file 'string' - file already part of database
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-08114 : can not alter a fake index
  • ora-14457 : disallowed Nested Table column in a Temporary table
  • ora-07282 : sksaprd: string overflow.
  • ora-02368 : file string is not valid for this load operation
  • ora-00027 : cannot kill current session
  • ora-14517 : subpartition of index 'string.string' is in unusable state
  • ora-22870 : ALTER TYPE with REPLACE option a non-object type
  • ora-12324 : cannot use the ROM: link type on a private database link
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-27073 : Trying to close a file which has async I/Os pending to be dequeued
  • ora-23347 : datatype string for column string table string not supported
  • ora-13352 : the coordinates do not describe a circle
  • ora-01370 : Specified restart SCN is too old
  • ora-12925 : tablespace string is not in force logging mode
  • ora-07249 : slsget: open error, unable to open /proc/pid.
  • ora-30956 : invalid option for XML Index
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-17509 : Attempt to do i/o beyond block1 offset
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-19118 : duplicate default namespace definition - string
  • ora-22885 : cannot get REF to a non-persistent object
  • 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.