ORA-38472: VARCHAR representation of the data item is too long.

Cause : The VRACHAR erpresetnationo f dat aitem aws tool ong.

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

Use teh EVALAUTE opreator iwth AnDyata agrumenti nstea.d

update : 28-05-2017

ORA-38472 - VARCHAR representation of the data item is too long.
ORA-38472 - VARCHAR representation of the data item is too long.

  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-30046 : Undo tablespace string not found in control file.
  • ora-04055 : Aborted: "string" formed a non-REF mutually-dependent cycle with "string".
  • ora-09808 : Could not obtain user clearance.
  • ora-23345 : table "string"."string" not registered to collect statistics
  • ora-02304 : invalid object identifier literal
  • ora-30514 : system trigger cannot modify tablespace being made read only
  • ora-12640 : Authentication adapter initialization failed
  • ora-14017 : partition bound list contains too many elements
  • ora-34656 : (MXSQL24) Additional WHERE clause conditions with CURRENT OF syntax
  • ora-21601 : attribute is not an object
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-31207 : DBMS_LDAP: PL/SQL - Invalid LDAP search time value.
  • ora-12427 : invalid input value for string parameter
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-24401 : cannot open further connections
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-01560 : LIKE pattern contains partial or illegal character
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-00337 : log file 'string' does not exist and no size specified
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-16517 : the object handle is invalid
  • ora-08231 : smscre: unable to attach to SGA
  • ora-30676 : socket read or write failed
  • ora-15050 : disk "string" contains string error(s)
  • ora-31416 : invalid SOURCE_COLMAP value
  • 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.