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-04050: invalid or missing procedure, function, or package name

1 Answers  


ORA-02710: osnpop: fork failed

1 Answers  


ORA-29954: domain index partition is marked LOADING/FAILED/UNUSABLE

1 Answers  


TNS-12510: TNS:database temporarily lacks resources to handle the request

1 Answers  


ORA-24021: queue table definition not imported for string.string

1 Answers  


ORA-00976: LEVEL, PRIOR, or ROWNUM not allowed here

2 Answers  


ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

1 Answers  


LSX-00201: contents of "~S" should be elements only

1 Answers  


IMG-00921: threshold out of range

1 Answers  


ORA-13356: adjacent points in a geometry are redundant

1 Answers  


IMP-00013: only a DBA can import a file exported by another DBA

1 Answers  


ORA-12404: invalid privilege string: string

1 Answers  


Categories