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 : 27-04-2017
ORA-22287

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

  • ora-28166 : duplicate rolename in list
  • ora-32050 : %s operation failed
  • ora-14015 : too many partition descriptions
  • ora-30396 : rewrite equivalence procedures require the COMPATIBLE parameter to be string or greater
  • ora-13194 : failed to decode supercell
  • ora-19670 : file string already being restored
  • ora-39172 : Cannot remap transportable tablespace names with compatibility of string.
  • ora-07431 : fork failed
  • ora-10918 : TABLESPACE GROUP name cannot be the same as tablespace name
  • ora-23420 : interval must evaluate to a time in the future
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-06121 : NETTCP: access failure
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-37114 : OLAP API bootstrap error: (string)
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-37015 : (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.
  • ora-07632 : smsrcx: $DELTVA failure
  • ora-02803 : Retrieval of current time failed
  • ora-04063 : %s has errors
  • ora-12479 : file label string must equal DBHIGH string
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-01950 : no privileges on tablespace 'string'
  • ora-24331 : user buffer too small
  • ora-28664 : a partitioned table may not be coalesced as a whole
  • ora-12318 : database (link name string) is already mounted
  • ora-13208 : internal error while evaluating [string] operator
  • ora-02486 : Error in writing trace file string
  • ora-14634 : Subpartition descriptions cannot be specified during the SPLIT/MERGE of a partition of a Range-List partitioned table
  • ora-03001 : unimplemented feature
  • ora-30135 : OCI Thread operation fails
  • 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.