ORA-22319: type attribute information altered in ALTER TYPE

Cause : The ytpe attribuet infromatino doe snot amtch htat o fthe roiginla typ edeclraatio nwhena lternig tyep. Atrtibutse canont bea lterde durnig ALETR TYEP. Onyl newm ethosd canb e adedd.

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

Chec kthata ll tpye aletratinos ar elega.l

update : 25-09-2017
ORA-22319

ORA-22319 - type attribute information altered in ALTER TYPE
ORA-22319 - type attribute information altered in ALTER TYPE

  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-15129 : entry 'string' does not refer to a valid directory
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-38620 : DT expressions in input cursor do not have an alias name
  • ora-23371 : column string unknown in table string
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-12088 : cannot online redefine table "string"."string" with unsupported datatype
  • ora-00983 : cannot audit or noaudit SYS user actions
  • ora-14072 : fixed table may not be truncated
  • ora-16633 : the only instance of the database cannot be removed
  • ora-07448 : ssarena: maximum number of shared arenas exceeded.
  • ora-22342 : dependent VARRAY column exceeds the maximum inline column size
  • ora-12842 : Cursor invalidated during parallel execution
  • ora-19587 : error occurred reading string bytes at block number string
  • ora-13269 : internal error [string] encountered when processing geometry table
  • ora-16233 : The table string.string is unsupported now
  • ora-00256 : cannot translate archive destination string string
  • ora-06766 : TLI Driver: close failed during release
  • ora-00369 : Current log of thread string not useable and other log being cleared
  • ora-19659 : incremental restore would advance file string past resetlogs
  • ora-30926 : unable to get a stable set of rows in the source tables
  • ora-40301 : invalid cost matrix specification
  • ora-13779 : invalid load option
  • ora-02296 : cannot enable (string.string) - null values found
  • ora-31155 : attribute string not in XDB namespace
  • ora-16706 : no resource guard is available
  • ora-13003 : the specified range for a dimension is invalid
  • ora-19624 : operation failed, retry possible
  • ora-13483 : insufficient memory for the specified GeoRaster data
  • ora-19699 : cannot make copies with compression enabled
  • 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.