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

DRG-50868: failed to free statement handle

1 Answers  


NNC-00420: operation not allowed

1 Answers  


LCD-00212: runaway quoted string [string]

1 Answers  


ORA-00316: log string of thread string, type string in header is not log file

1 Answers  


ORA-00827: could not shrink sga_target to specified value

1 Answers  


ORA-23490: extension request "string" with status "string" not allowed in this operation

1 Answers  


ORA-30432: summary 'string.string' is in INVALID state

1 Answers  


ORA-02832: Segment deallocation failed - segment not on list

1 Answers  


PLS-00599: SAMPLE percentage must be in the range [0.000001,100)

1 Answers  


NNO-00262: warning: cannot write checkpoint file "string"

1 Answers  


ORA-25223: user_data type used is not supported

1 Answers  


ORA-08233: smsdes: cannot unmap SGA

2 Answers  


Categories