ORA-22803: object type contains zero attributes

Cause : A nattepmtw a smdaet oc raet eo rsepcfiya oclmuno rc osnturcotro fa no bejc ttpyet hta ahsn oa trtiubtse.O nyl bojcett yepst hta ahv ea tlaes toen tatirbtuea r ealloewdi nt hsi ocnetx.t

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

sepcfiya avldi bojcett yep

update : 28-06-2017
ORA-22803

ORA-22803 - object type contains zero attributes
ORA-22803 - object type contains zero attributes

  • ora-16646 : Fast-Start Failover is disabled
  • ora-00287 : specified change number string not found in thread string
  • ora-31183 : Node type string cannot be converted to desired type
  • ora-29664 : Unable to generate the helper class for the defined type
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-01623 : log string is current log for instance string (thread string) - cannot drop
  • ora-01301 : error writing to file during flat file build
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-30356 : the specified refresh method is not supported in this context
  • ora-40201 : invalid input parameter string
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-28362 : master key not found
  • ora-09977 : skxfqhini: Error Connecting
  • ora-01233 : file string is read only - cannot recover using backup control file
  • ora-30071 : conversion between datetime/interval and string fail
  • ora-07489 : scgrcl: cannot get lock status.
  • ora-12828 : Can't start parallel transaction at a remote site
  • ora-32307 : must use FROM ONLY clause when referencing an object table
  • ora-26103 : V6 or V7 data file used to create control file
  • ora-12443 : policy not applied to some tables in schema
  • ora-01904 : DATAFILE keyword expected
  • ora-09265 : spwat: error temporarily suspending process
  • ora-16602 : object must be disabled to perform this operation
  • ora-13119 : invalid edge_id [string]
  • ora-29312 : changes by release string cannot be used by release string, type: string
  • ora-02024 : database link not found
  • ora-06770 : TLI Driver: error sending version
  • ora-10638 : Index status is invalid
  • ora-08440 : raw buffer is too short to hold converted data
  • 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.