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 : 20-09-2017
ORA-12585

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

  • ora-15168 : rolling downgrade prevented by string
  • ora-15173 : entry 'string' does not exist in directory 'string'
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-16582 : could not edit instance specific property
  • ora-25401 : can not continue fetches
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-24401 : cannot open further connections
  • ora-00312 : online log string thread string: 'string'
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-07426 : spstp: cannot obtain the location of dbs directory.
  • ora-02755 : osnfsmcre: cannot create chared memory file ?/dbs/ftt_.dbf
  • ora-30107 : parameter name abbreviation 'string' is not unique
  • ora-30153 : An invalid File Object is passed to the OCIFile function
  • ora-13108 : spatial table string not found
  • ora-09203 : sfofi: error opening file
  • ora-24166 : evaluation context string.string has errors
  • ora-36802 : (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.
  • ora-39136 : cannot specify an SCN on a transportable job
  • ora-39307 : operation is illegal without an initial clone
  • ora-30680 : debugger connection handshake failed
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-09354 : Windows 32-bit Two-Task driver: ORACLE task unexpectedly died
  • ora-29662 : Unable to find a field that matches one or more of the attributes
  • ora-16211 : unsupported record found in the archived redo log
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-28054 : the password has expired. string Grace logins are left
  • ora-29313 : tablespace 'string' cannot be imported twice
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-32033 : unsupported column aliasing
  • ora-13844 : no new SQL profile name or category specified.
  • 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.