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

PCC-02450: Cursor was not declared in scrollable mode

1 Answers  


ORA-13524: error encountered while retrieving baseline information

1 Answers  


ORA-30395: dimension options require the COMPATIBLE parameter to be string or greater

1 Answers  


ORA-01272: REUSE only allowed when a file name is provided.

1 Answers  


ORA-25203: invalid value string, DELAY should be non-negative

1 Answers  


ORA-25149: Columns of UROWID type may not be indexed

1 Answers  


DRG-11130: no data found in the collection

1 Answers  


ORA-29285: file write error

1 Answers  


ORA-32127: REFs do not belong to any connection

1 Answers  


ORA-13044: the specified tile size is smaller than the tolerance

1 Answers  


ORA-26685: cannot apply transactions from multiple sources

1 Answers  


LSX-00215: value "~1S" whose total digits exceeds ~2d

1 Answers  


Categories