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 : 18-08-2017
ORA-22994

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-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-40306 : wide data not supported for decision tree model create
  • ora-22628 : OCIAnyData already constructed
  • ora-32333 : disable table scn update for Materialized view
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-12025 : materialized view log on "string"."string" already has primary keys
  • ora-16574 : switchover disallowed when required databases are offline
  • ora-19668 : cannot do full restore of datafile string
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-24265 : Insufficient privileges for SQL profile operation
  • ora-31019 : Recursive deletion snapshot too old for string/string
  • ora-02058 : no prepared transaction found with ID string
  • ora-19023 : The first argument to UPDATEXML operator has to be an XMLTYPE
  • ora-13344 : an arcpolygon geometry has fewer than five coordinates
  • ora-27147 : post/wait reset failed
  • ora-29254 : Invalid lower_bound argument passed to procedure dbms_sql.define_array
  • ora-00972 : identifier is too long
  • ora-01315 : Log file has been added or removed during select
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-28234 : key length too short
  • ora-00302 : limit of string logs exceeded
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-07577 : no such user in authorization file
  • ora-24086 : cannot create a 8.0 compatible string queue
  • ora-08182 : operation not supported while in Flashback mode
  • ora-31480 : staging database and source database cannot be the same
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-19915 : unable to encrypt pre-10.2 files
  • 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.