ORA-24348: Update or Delete without Where

Cause : An update or delete was executed without where clause

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


update : 30-04-2017

ORA-24348 - Update or Delete without Where
ORA-24348 - Update or Delete without Where

  • ora-29292 : file rename operation failed
  • ora-19208 : parameter string of function string must be aliased
  • ora-03217 : invalid option for alter of TEMPORARY TABLESPACE
  • ora-24311 : memory initialization failed
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-16762 : invalid database state
  • ora-32407 : cannot exclude new values when materialized view log includes new values
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-00038 : Cannot create session: server group belongs to another user
  • ora-25289 : Buffer Already Exists
  • ora-01260 : warning: END BACKUP succeeded but some files found not to be in backup mode
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-00826 : cannot set sga_target for an ASM instance
  • ora-12536 : TNS:operation would block
  • ora-29383 : all leaves of top-plan string must be consumer groups
  • ora-28040 : No matching authentication protocol
  • ora-04080 : trigger 'string' does not exist
  • ora-27066 : number of buffers in vector I/O exceeds maximum
  • ora-31687 : error creating worker process string with worker id string
  • ora-30475 : feature not enabled: string
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-14514 : LOCAL option not valid without subpartition name
  • ora-19901 : database needs more recovery to create new incarnation
  • ora-07860 : osnsoi: error setting up interrupt handler
  • ora-22971 : invalid datatype for PRIMARY KEY-based object identifier
  • ora-31506 : duplicate subscription name string
  • ora-13348 : polygon boundary is not closed
  • ora-16584 : illegal operation on a standby site
  • ora-12853 : insufficient memory for PX buffers: current stringK, max needed stringK
  • 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.