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-14132: table cannot be used in EXCHANGE

1 Answers  


SQL*Loader-00620: Initial enclosure character not found

1 Answers  


ORA-28656: incomplete attribute specification

1 Answers  


ORA-06321: IPA: Cannot reach the remote side

1 Answers  


RMAN-03038: Spooling started in trace file: string

1 Answers  


RMAN-06422: no channels found for SEND command

1 Answers  


ORA-28300: No permission to read user entry in LDAP directory service.

1 Answers  


NID-00371: Change database name of database string to string? (Y/[N]) =>

1 Answers  


ORA-12409: policy startup failure for string policy

1 Answers  


ORA-01194: file string needs more recovery to be consistent

1 Answers  


ORA-06753: TLI Driver: name-to-address mapping failed

1 Answers  


LPX-00307: namespace prefix ~S used but not declared

1 Answers  


Categories