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-00428: count for field string not stored in character or integer field

1 Answers  


ORA-01019: unable to allocate memory in the user side

2 Answers  


NPL-00305: unsupported ASN.1 "UNIV" type string

1 Answers  


ORA-37028: (XSMLTRESYNC03) Object workspace object cannot be resynced without modified object workspace object because they share a modified dimension map.

1 Answers  


QSM-01027: materialized view, string, is unusable

1 Answers  


PLS-00562: a function must return a type.

1 Answers  


ORA-36666: (XSDPART04) workspace object is not a concat dimension.

1 Answers  


ORA-24054: cannot propagate to an Oracle 8.0.3 release or lower release

1 Answers  


ORA-15185: Could not close dynamic library string, error [string]

1 Answers  


QSM-01033: query rewritten with materialized view, string

1 Answers  


ORA-26012: No data found while executing sql statement string for column string - check input for: string

1 Answers  


ORA-36978: (XSRELGID01) workspace object must be a self-relation.

1 Answers  


Categories