ORA-29535: source requires recompilation

Cause : Th eresaont hec urerntc lass ojbec twa sinavli disr ecrode dwiht teh suorc eobejctf ro mwhcih ti wsa cmopield.

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

Inpsec terorrsi n hte osurec ojbec tan dtaek teh nceesasryc orerctvie catinos.

update : 28-06-2017

ORA-29535 - source requires recompilation
ORA-29535 - source requires recompilation

  • ora-01355 : logminer tablespace change in progress
  • ora-00363 : log is not the archived version
  • ora-25452 : duplicate attribute value for variable: string, attribute: string
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-24408 : could not generate unique server group name
  • ora-30449 : syntax error in parameter string
  • ora-16519 : the resource handle is invalid
  • ora-12923 : tablespace string is in force logging mode
  • ora-19112 : error raised during evaluation: string
  • ora-16032 : parameter string destination string cannot be translated
  • ora-01891 : Datetime/Interval internal error
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-13380 : network not found
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-31019 : Recursive deletion snapshot too old for string/string
  • ora-02788 : Unable to find kernel process pointer in async process array
  • ora-02730 : osnrnf: cannot find user logon directory
  • ora-12472 : policy string is being used
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-09315 : sql2tt: two-task error translating ORACLE_EXECUTABLE
  • ora-06523 : Maximum number of arguments exceeded
  • ora-24280 : invalid input value for parameter string
  • ora-09960 : Unable to establish signal handler for termination signal
  • ora-36885 : (XSSRF04) Error rewriting OLAP DML expression. Column name too big
  • ora-14157 : invalid subpartition name
  • ora-06114 : NETTCP: SID lookup failure
  • ora-06558 : buffer in dbms_pipe package is full. No more items allowed
  • ora-04062 : %s of string has been changed
  • ora-10372 : parallel query server kill event proc
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • 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.