ORA-22308: operation not allowed on evolved type

Cause : An attemptw as mdae tor eplaec a tpye whsoe atrtibut edefiintionb een eben atlered.

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

Submti ALTRE TYP EADD/RDOP sattemetn insetad o fALTE RTYPER EPLAEC.

update : 28-04-2017
ORA-22308

ORA-22308 - operation not allowed on evolved type
ORA-22308 - operation not allowed on evolved type

  • ora-02310 : exceeded maximum number of allowable columns in table
  • ora-13607 : The specified task or object string already exists
  • ora-06711 : TLI Driver: error on bind
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-06752 : TLI: error in signal setup
  • ora-16143 : RFS connections not allowed during or after terminal recovery
  • ora-31209 : DBMS_LDAP: PL/SQL - LDAP count_entry error.
  • ora-07391 : sftopn: fopen error, unable to open text file.
  • ora-08207 : ora_addr: cannot open address file
  • ora-16017 : cannot use LOG_ARCHIVE_DUPLEX_DEST without a primary archive destination
  • ora-24414 : Only number sessions could be started.
  • ora-03248 : Too much of segment creation activity during migration
  • ora-14115 : partition bound of partition number string is too long
  • ora-32021 : parameter value longer than string characters
  • ora-29908 : missing primary invocation for ancillary operator
  • ora-02234 : changes to this table are already logged
  • ora-13263 : column string in table string is not of type SDO_GEOMETRY
  • ora-30438 : unable to access named pipe 'string'
  • ora-31481 : change source string is not a HotLog change source
  • ora-38709 : Recovery Area is not enabled.
  • ora-31533 : only one change set (string) is allowed in change source
  • ora-12336 : cannot login to database (link name string)
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-16574 : switchover disallowed when required databases are offline
  • ora-07218 : slkhst: could not perform host operation
  • ora-31621 : error creating master process
  • ora-31463 : logfile location string is an empty directory
  • ora-13156 : table to be registered string.string is not empty
  • ora-00056 : DDL lock on object 'string.string' is already held in an incompatible mode
  • ora-24336 : invalid result set descriptor
  • 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.