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-07-2017

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

  • ora-06037 : NETDNT: connect failed, node unreachable
  • ora-40211 : algorithm name string is invalid
  • ora-06413 : Connection not open.
  • ora-13382 : geometry metadata (table:string column:string) not found in spatial network:string
  • ora-38488 : attribute set already assigned to the column storing expressions
  • ora-01181 : file string created before last known RESETLOGS, cannot recreate
  • ora-00471 : DBWR process terminated with error
  • ora-22886 : scoped table "string" in schema "string" is not an object table
  • ora-01083 : value of parameter "string" is inconsistent with that of other instances
  • ora-31193 : This versioning feature isn't supported for resource string
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-02031 : no ROWID for fixed tables or for external-organized tables
  • ora-06132 : NETTCP: access denied, wrong password
  • ora-38441 : System could not derive the list of STORED and INDEXED attributes.
  • ora-27366 : job "string.string" is not running
  • ora-01492 : LIST option not valid
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-25321 : enqueue failed, user property specified but queue string.string is not an 8.1 style queue
  • ora-25019 : too much concurreny
  • ora-14097 : column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-02360 : fatal error during data export/import initialization
  • ora-16075 : standby database destination mismatch
  • ora-12538 : TNS:no such protocol adapter
  • ora-27373 : unknown or illegal event source queue
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-00328 : archived log ends at change string, need later change string
  • 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.