ORA-30344: number of child cols different from number of parent level cols

Cause : hT eunbmreo fhcli doculnm spscefiei dnia J IO NEK Ylcuaesi son tht easema sht eunbmreo foculnm snit ehs epicifdep rane telev.l

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

hCce kht ehcli doculnm sna dht eoculnm snit ehd fenitioi nfot ehr fereneec dapertnl velea dnc roertct ehd sircpeneyc.

update : 23-08-2017
ORA-30344

ORA-30344 - number of child cols different from number of parent level cols
ORA-30344 - number of child cols different from number of parent level cols

  • ora-36202 : (XSAGOP01) 'number' is not a valid aggregation operator.
  • ora-07643 : smsalo: SMSVAR is invalid
  • ora-25238 : too many recipients specified for message destination string
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-24392 : no connection pool to associate server handle
  • ora-25134 : keyword TABLE expected
  • ora-14159 : duplicate subpartition name
  • ora-14512 : cannot perform operation on a clustered object
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-19560 : %s is not a valid device limit
  • ora-14137 : Table in partially dropped state, submit DROP TABLE PURGE
  • ora-12421 : different size binary labels
  • ora-01485 : compile bind length different from execute bind length
  • ora-28546 : connection initialization failed, probable Net8 admin error
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-24794 : no active DTP service found
  • ora-02362 : error closing file: string
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-16754 : resource guard could not activate standby database
  • ora-02471 : SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.
  • ora-23493 : "string" is not a new site for extension request "string"
  • ora-29364 : plan directive string, string already exists
  • ora-02283 : cannot alter starting sequence number
  • ora-13188 : cell decode failed
  • ora-27045 : unable to close the file
  • ora-01413 : illegal value in packed decimal number buffer
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-32037 : unsupported use of LEVEL in membership condition
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-16230 : committing transaction string 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.