ORA-22287: invalid or modified directory occurred during string operation

Cause : Th edierctroy laia susde fro teh cruretn oepraitoni s ont avli difb eign accesesd ofr hte ifrs ttiem, ro hsa been omdiifedb y hte BDA isnc eth elats acces.s

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

Ify oua rea ccsesign tihs idretcor yfo rth efisrt itme ,prvoid ea avli ddierctroy anme .Ify ouh av ebene arleayd scucessfu lino peinnga flie nude rthsi driecotryb efroe htise rrro occurde, htenc loes teh flie nad ertr yth eopreatoin iwtha vlaidd ircetoyr ailasa s omdiifedb y oyurD BA .Orcaler ecmomedns htatd ircetoiress holud eb mdoifeid nolyd urnig uqiecsen tpeirod.s

update : 18-08-2017
ORA-22287

ORA-22287 - invalid or modified directory occurred during string operation
ORA-22287 - invalid or modified directory occurred during string operation

  • ora-13336 : failure in converting standard diminfo/geometry to LRS dim/geom
  • ora-12558 : TNS:protocol adapter not loaded
  • ora-26714 : User error encountered while applying
  • ora-02373 : Error parsing insert statement for table string.
  • ora-37142 : (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
  • ora-01210 : data file header is media corrupt
  • ora-09853 : snyRemovePort: bad return code from request.
  • ora-39177 : invalid compression value string
  • ora-30115 : error when processing an environment variable
  • ora-12483 : label not in OS system accreditation range
  • ora-29509 : incorrectly formed Java binary class definition
  • ora-10563 : Test recovery had to corrupt data block (file# string, block# string) in order to proceed
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-13756 : Cannot update attribute "string".
  • ora-24808 : streaming of lob data is not allowed when using lob buffering
  • ora-12426 : invalid audit option
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-02818 : Less than the number of blocks requested was read in
  • ora-01553 : MAXEXTENTS must be no smaller than the string extents currently allocated
  • ora-01231 : cannot make read write - file string is offline
  • ora-14637 : cannot merge a subpartition with itself
  • ora-40204 : model string already exists
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-01675 : max_commit_propagation_delay inconsistent with other instances
  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-22853 : invalid LOB storage option specification
  • ora-31216 : DBMS_LDAP: PL/SQL - Invalid LDAP rdn.
  • 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.