Oracle Database Errors or Warnings from Error ORA-22334 to ORA-22343

SQLServerF1

ORA-22334: cannot reset type “string”.”string”. Dependent tables must be upgraded to latest version
Cause: An attempt was made to reset the type version when the data in the dependent table has not been upgraded to the latest type version.
Action: Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.
ORA-22335: The client cannot work with an altered type
Cause: A pre 8.2 client has requested a type that has been altered on the server.
Action: Only 8.2 or higher clients could access altered types
ORA-22336: table contained 8.0 image format, must specify INCLUDING DATA
Cause: One of the following: 1) An attempt was made to alter a type with a dependent table in 8.0 image format and the NOT INCLUDING TABLE DATA option was specified. 2) An attempt was made to upgrade a table in 8.0 image format with the NOT INCLUDING DATA option specified.
Action: Resubmit the statement with INCLUDING DATA option.

ORA-22337: the type of accessed object has been evolved
Cause: The type of the accessed object has been altered and the client’s object is based on an earlier type definition.
Action: The user needs to exit application and modify application to accommodate the type change. From SQL/PLUS, reconnect and resubmit statement.
ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property
Cause: An attempt was made to alter the final property of a type with dependent table(s) without specifying the CASCADE INCLUDING DATA . option.
Action: Resubmit the statement with the CASCADE INCLUDING DATA option.
ORA-22339: cannot alter to not final since its attribute column is substitutable
Cause: An attempt was made to alter a type to not final when its embedded attribute is defined as substitutable in some tables. Note, this is a restriction in 9.0 version because when a type is altered to not final, column of that type is set to not substitutable at all levels; thus, it is an error if one of its embedded attribute column is already marked substitutable.
Action: Recreate the table and specify NOT SUBSTITUTABLE AT ALL LEVELS for all columns of non final type. Then resubmit the ALTER TYPE statement.

ORA-22340: cannot string type “string”.”string”. Dependent tables must be upgraded to latest version
Cause: An attempt was made to reset the version, drop or alter a type when the data in dependent table has not been upgraded to the latest version.
Action: Use the ALTER TABLE UPGRADE INCLUDING DATA statement to upgrade the data in the dependent tables then resubmit the statement.
ORA-22341: cannot assign supertype instance to subtype
Cause: An attempt was made to assign or copy a supertype instance to a container (destination) that can only hold a subtype instance.
Action: Make sure the runtime type of the source of the assignment or copy is the same type as the destination or is a subtype of the destination type
ORA-22342: dependent VARRAY column exceeds the maximum inline column size
Cause: An attempt was made to alter a type (add or modify attribute) which causes the size of its dependent VARRAY column to exceed the maximum inline column size. However, the VARRAY column was not specified to be stored as LOB at the table level when the table was created.
Action: Specify the VARRAY column to be stored as LOB at the table level when the table is created.
ORA-22343: Compilation error for type invalidated by ALTER TYPE
Cause: Compilation failed for a type which was invalidated by ALTER TYPE. We throw this error and rollback the compilation effort so that the user may be able to fix whatever is causing the compilation error and try again. It is important that we do not chnage status here and modify the dependency information as this will affect the creation of versions.
Action: Check what is causing teh compilation error and correct it and try again.

Above are list of Oracle Database Errors or Warnings from Error ORA-22334 to ORA-22343 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *