ORA-22994: source offset is beyond the end of the source LOB

Cause : Thes ourec ofsfet ofr aL OB OCPY ro LO BLOAFDROMIFLE si beoynd hte edn oft he osurc eLOB.

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

Chekc th elentgh o ftheL OB nad tehn ajdustt he osurc eoffest.

update : 28-04-2017

ORA-22994 - source offset is beyond the end of the source LOB
ORA-22994 - source offset is beyond the end of the source LOB

  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-12689 : Server Authentication required, but not supported
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-01571 : redo version string incompatible with ORACLE version string
  • ora-16228 : Insufficient recovery for logical standby
  • ora-37008 : (AWLISTALL06) number writers
  • ora-19550 : cannot use backup/restore functions while using dispatcher
  • ora-25108 : standby lock name space exceeds size limit of string characters
  • ora-09822 : Translation of audit file name failed.
  • ora-19802 : cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE
  • ora-10627 : Dump the content of the index leaf block
  • ora-04080 : trigger 'string' does not exist
  • ora-36806 : (XSTBLFUNC03) The OLAP_TABLE function refers to an invalid ADT attribute: string.
  • ora-01211 : Oracle7 data file is not from migration to Oracle8
  • ora-36966 : (XSRELTBL10) workspace object must be a dimension.
  • ora-15024 : discovered duplicately numbered ASM disk string
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-36862 : (XSTFRC02) Column number for this SQL Cache must be between 1 and number. Specified column number number is invalid.
  • ora-00217 : control file could not be resized for new record types
  • ora-24382 : statement handled already executed or described
  • ora-01919 : role 'string' does not exist
  • ora-02098 : error parsing index-table reference (:I)
  • ora-02357 : no valid dump files
  • ora-31167 : XML nodes over 64K in size cannot be inserted
  • ora-30065 : test support for row dependencies
  • ora-12820 : invalid value for DEGREE
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-17508 : I/O request buffer ptr is not alligned
  • ora-09352 : Windows 32-bit Two-Task driver unable to spawn new ORACLE task
  • ora-36669 : (XSDPART07) string is not a legal LIST partition.
  • 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.