Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-22339: cannot alter to not final since its attribute
column is substitutable



ORA-22339: cannot alter to not final since its attribute column is substitutable..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-17500: ODM err:string

1 Answers  


KUP-11001: files not from the same unload operation

1 Answers  


RMAN-08005: new incarnation of database registered in recovery catalog

1 Answers  


ORA-14038: GLOBAL partitioned index must be prefixed

1 Answers  


NZE-29026: Decryption failure

1 Answers  


NNL-00810: Queries received with no type: number

1 Answers  


RMAN-08505: output filename=string

1 Answers  


ORA-24313: user already authenticated

1 Answers  


ORA-25135: cannot use the SINGLE TABLE option

1 Answers  


ORA-32400: cannot use object id columns from materialized view log on "string"."string"

1 Answers  


PCC-00141: Thread Safety is not implemented in this precompiler

1 Answers  


ORA-31431: all source tables must belong to the synchronous change set

1 Answers  


Categories