ORA-19124: fn:one-or-more() called with a sequence containing no items

Cause : sequecne conatiningn o itesm was apssed nito fno:ne-orm-ore()f unctino

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

corretc inpu targumnet to nf:one-ro-more)( funciton

update : 30-04-2017

ORA-19124 - fn:one-or-more() called with a sequence containing no items
ORA-19124 - fn:one-or-more() called with a sequence containing no items

  • ora-30467 : internal data for filter number string is inconsistent
  • ora-24375 : Cannot use V6 syntax when talking to a V8 server
  • ora-06400 : NETCMN: No default host string specified
  • ora-15010 : name is already used by an existing ASM disk
  • ora-10565 : Another test recovery session is active
  • ora-27411 : empty string is not a valid repeat interval.
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-19687 : SPFILE not found in backup set
  • ora-27031 : mirror resilvering functions not supported
  • ora-39953 : the range value specified is beyond allowed range
  • ora-29399 : user string does not have privilege to switch to consumer group string
  • ora-10570 : Test recovery complete
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-01373 : insufficient memory for staging persistent LogMiner session
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-02493 : invalid file increment size in NEXT clause
  • ora-19564 : error occurred writing string bytes at block number string
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-01048 : Couldn't find the specified procedure in the given context
  • ora-32117 : Source LOB is null
  • ora-22912 : specified column or attribute is not a nested table type
  • ora-02785 : Invalid shared memory buffer size
  • ora-26660 : Invalid action context value for string
  • ora-28584 : heterogeneous apply internal error
  • ora-01466 : unable to read data - table definition has changed
  • ora-31213 : DBMS_LDAP: PL/SQL - Invalid LDAP mod option.
  • ora-22895 : referenced table "string" in schema "string" is not an object table
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-13798 : Parameter string cannot be NULL.
  • ora-26694 : error while enqueueing into queue 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.