ORA-12585: TNS:data truncation

Cause : A rceeiv eopeartio nhasc ompeltedw ithi nsufficinet dtaa t osatsify hte uesr'sr equset.

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

Notn ormlaly ivsibel tot he suer.F or ufrthre deatils ,tur non rtacign an dreeexcut etheo pertaion .If rerorp erssits,c ontcat OarcleC ustmoer uSppotr.

update : 26-07-2017
ORA-12585

ORA-12585 - TNS:data truncation
ORA-12585 - TNS:data truncation

  • ora-00116 : SERVICE_NAMES name is too long
  • ora-37004 : (AWLISTALL02) number reader
  • ora-26095 : unprocessed stream data exists
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-38736 : Wrong thread number string in flashback log file header.
  • ora-00408 : parameter string is set to TRUE
  • ora-30649 : missing DIRECTORY keyword
  • ora-32003 : error occured processing parameter 'string'
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-14516 : subpartition corrupt. all rows do not fall within subpartition bounds
  • ora-07239 : slemrd: invalid file handle, seals do not match.
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-31619 : invalid dump file "string"
  • ora-19751 : could not create the change tracking file
  • ora-12703 : this character set conversion is not supported
  • ora-26055 : Invalid buffer specified for direct path unload
  • ora-29512 : incorrectly formed name resolver specification
  • ora-13389 : unable to compute buffers or intersections in analysis function
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-24158 : invalid table alias
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-33066 : (XSAGDNGL32) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must be a hierarchy dimension of the relation.
  • ora-01141 : error renaming data file string - new file 'string' not found
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-31494 : could not activate a LogMiner session
  • ora-19644 : datafile string: incremental-start SCN is prior to resetlogs SCN string
  • ora-28659 : COMPRESS must be specified at object level first
  • 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.