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 : 25-06-2017
ORA-22287

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

  • ora-00054 : resource busy and acquire with NOWAIT specified
  • ora-29844 : duplicate operator name specified
  • ora-30380 : REWRITE_TABLE does not exist
  • ora-33009 : (XSAGDNGLPREC) In AGGMAP workspace object, PRECOMPUTE may only be specified either for the entire AGGMAP or for individual RELATION statements.
  • ora-32127 : REFs do not belong to any connection
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-07240 : slemrd: seek error.
  • ora-22862 : specified object identifier doesn't match existing object identifier
  • ora-39700 : database must be opened with UPGRADE option
  • ora-31527 : could not find source column string for CDC change table string.string
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-26698 : %s did not have a string rule set
  • ora-00220 : control file not mounted by first instance, check alert log for more info
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-22957 : NULL is an invalid input to powermultiset and COLLECT functions
  • ora-14313 : Value string does not exist in partition string
  • ora-19575 : expected string blocks in file string, found string
  • ora-31672 : Worker process string died unexpectedly.
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-14402 : updating partition key column would cause a partition change
  • ora-00489 : ARB* process terminated with error
  • ora-01931 : cannot grant string to a role
  • ora-01881 : timezone region id number is invalid
  • ora-16804 : one or more configuration properties in metadata have invalid values
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-09283 : sllfsk: error skipping records
  • ora-22309 : attribute with name "string" already exists
  • ora-26033 : column string.string encryption properties differ for source or target table
  • 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.