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

SQL*Loader-00712: Internal error: bad address for big endian UTF16 conversion

1 Answers  


NNC-00424: invalid address "string"

1 Answers  


ORA-28117: integrity constraint violated - parent record not found

1 Answers  


KUP-04080: directory object string not found

1 Answers  


PCC-01019: Invalid conversion buffer size

1 Answers  


ORA-31674: worker process interrupt for unhandled exception in master process

1 Answers  


SQL*Loader-00430: NULL nested table element is not allowed

1 Answers  


PLS-00213: package STANDARD not accessible

1 Answers  


ORA-16952: Failed to bind this SQL statement.

1 Answers  


ORA-30161: A system error occurred during the OCIFile function call

1 Answers  


O2U-00212: An error occurred for which no message is available

1 Answers  


IMG-00602: unable to access image data

1 Answers  


Categories