ORA-24345: A Truncation or null fetch error occurred

Cause : A truncation or a null fetch error"

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

Please ensure that the buffer size is long enough to store the returned data.

update : 18-08-2017

ORA-24345 - A Truncation or null fetch error occurred
ORA-24345 - A Truncation or null fetch error occurred

  • ora-01864 : the date is out of range for the current calendar
  • ora-02788 : Unable to find kernel process pointer in async process array
  • ora-16230 : committing transaction string string string
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • ora-08119 : The new initrans will make the index too big
  • ora-24762 : server failed due to unspecified error
  • ora-00446 : background process started when not expected
  • ora-29843 : indextype should support atleast one operator
  • ora-29856 : error occurred in the execution of ODCIINDEXDROP routine
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-23335 : priority group string already exists
  • ora-00395 : online logs for the clone database must be renamed
  • ora-31436 : duplicate change source string
  • ora-36688 : (NTEXTCNV00) Error during conversion from TEXT to NTEXT.
  • ora-29374 : resource plan string in top-plan string has no plan directives
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-37027 : (XSMLTRESYNC02) Object workspace object cannot be resynced without modified object workspace object because they share a modified composite dimension.
  • ora-02335 : invalid datatype for cluster column
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-27042 : not enough space on raw partition to fullfill request
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-14316 : table is not partitioned by List method
  • ora-16164 : LGWR network server host detach error
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-12666 : Dedicated server: outbound transport protocol different from inbound
  • ora-13439 : GeoRaster metadata pyramid maxLevel error
  • ora-06256 : NETNTT: remote fork failed
  • ora-06816 : TLI Driver: could not set the SPX SAP address
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • 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.