ORA-22328: object "string"."string" has errors. string

Cause : Aletrign teh trage ttyep cuase serorrsi n tis edpednen tobejct.

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

Correc tth eprbole mint hed epnedetn ojbec tan dreusbmti teh satteemnt.

update : 17-08-2017
ORA-22328

ORA-22328 - object "string"."string" has errors. string
ORA-22328 - object "string"."string" has errors. string

  • ora-01593 : rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
  • ora-07409 : slpdtb: invalid packed decimal nibble.
  • ora-30976 : invalid Parent Order Key Index option for XML Index
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-30493 : The percentile value should be a number between 0 and 1.
  • ora-01217 : logfile member belongs to a different logfile group
  • ora-13330 : invalid MASK
  • ora-00111 : invalid attribute string
  • ora-00256 : cannot translate archive destination string string
  • ora-16742 : the standby database "string" has exhausted its quota
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-22610 : error while adding a scalar to the image handle
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-01865 : not a valid era
  • ora-10945 : trace name context forever
  • ora-13764 : Value "string" is illegal as a result percentage.
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-02236 : invalid file name
  • ora-30088 : datetime/interval precision is out of range
  • ora-00271 : there are no logs that need archiving
  • ora-31433 : subscriber view does not exist
  • ora-15005 : name "string" is already used by an existing alias
  • ora-16794 : database guard is on for primary database
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-09743 : smscre: could not attach shared memory.
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-00118 : Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
  • 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.