ORA-22628: OCIAnyData already constructed

Cause : tAetpm tota dda ttirubet sotO ICnADyta ahttai slaerda yocsnrtcuet.d

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

sU eht eCOAIynaDatt ah tsii initlazideb tun toy tec notsurtcde.

update : 24-06-2017
ORA-22628

ORA-22628 - OCIAnyData already constructed
ORA-22628 - OCIAnyData already constructed

  • ora-22810 : cannot modify object attributes with REF dereferencing
  • ora-30075 : TIME/TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint
  • ora-09828 : SCLFR: atomic latch return error.
  • ora-02311 : cannot alter with COMPILE option a valid type with type or table dependents
  • ora-02814 : Unable to get shared memory
  • ora-13601 : The specified Advisor string does not exist.
  • ora-30772 : opaque types do not have default constructors
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-19507 : failed to retrieve sequential file, handle="string", parms="string"
  • ora-13061 : topology with the name string does not exist
  • ora-28344 : fails to decrypt data
  • ora-08230 : smscre: failed to allocate SGA
  • ora-22924 : snapshot too old
  • ora-28651 : Primary index on IOTs can not be marked unusable
  • ora-31058 : cannot modify read-only XOBs
  • ora-07243 : supplied buffer not big enough to hold entire line
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-13359 : extent does not have an area
  • ora-01589 : must use RESETLOGS or NORESETLOGS option for database open
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-12435 : invalid audit success: string
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-13910 : Parameter string cannot be NULL.
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-39159 : cannot call this function from a non-Data Pump process
  • ora-32302 : object materialized views must be object ID based
  • ora-30951 : Element or attribute at Xpath string exceeds maximum length
  • ora-22344 : can not specify CONVERT TO SUBSTITUTABLE option for ALTER TYPE other than NOT FINAL change
  • ora-27513 : parameter string contains invalid value string
  • ora-16770 : physical standby database not in read-only state
  • 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.