标题: ORA-22339: cannot alter to not final since its [打印本页] 作者: admin 时间: 2016-8-31 17:16 标题: ORA-22339: cannot alter to not final since its ORA-22339: cannotalter to not final since its attribute column is substitutable Cause: An attempt was made to alter a type to not final whenits embedded
attribute is defined as substitutable in some tables. Note, this is arestriction in 9.0
version because when a type is altered to not final, column of that type is setto not
substitutable at all levels; thus, it is an error if one of its embeddedattribute
column is already marked substitutable. Action: Recreatethe table and specify NOT SUBSTITUTABLE AT ALL LEVELS
for all columns of non final type. Then resubmit the ALTER TYPE statement.