ORA-01422: exact fetch returns more than requested number of rows

Cause : hT eunbmres epicifdei nxeca tefct hsil se shtnat ehr wo serutnrde.

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

eRrwti eht euqre yroc ahgn eunbmreo forswr qeeutsde

update : 20-09-2017

ORA-01422 - exact fetch returns more than requested number of rows
ORA-01422 - exact fetch returns more than requested number of rows

  • ora-19728 : data object number conflict between table string and partition string in table string
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-02092 : out of transaction table slots for distributed transaction
  • ora-19026 : EXTRACTVALUE can only retrieve value of leaf node
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-06438 : ssaio: the asynchronous read was unable to read from the database file.
  • ora-13159 : Oracle table string already exists
  • ora-13404 : invalid ultCoordinate parameter
  • ora-29532 : Java call terminated by uncaught Java exception: string
  • ora-31521 : CDC subscription string already subscribes to publication ID string column string
  • ora-31443 : deadlock detected while acquiring lock on string
  • ora-13147 : failed to generate MBR
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-12470 : NULL or invalid user label: string
  • ora-15004 : alias "string" does not exist
  • ora-00710 : new tablespace name is the same as the old tablespace name
  • ora-00490 : PSP process terminated with error
  • ora-13359 : extent does not have an area
  • ora-28040 : No matching authentication protocol
  • ora-02207 : invalid INITRANS option value
  • ora-00115 : connection refused; dispatcher connection table is full
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-07599 : spwat: $SCHDWK failure
  • ora-14259 : table is not partitioned by Hash method
  • ora-04043 : object string does not exist
  • ora-37000 : (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.
  • ora-19597 : file string blocksize string does not match set blocksize of string
  • ora-04051 : user string cannot use database link string.string
  • ora-26753 : Mismatched columns found in '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.