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-22857: cannot modify columns of object tables



ORA-22857: cannot modify columns of object tables..

Answer / guest

Cause: An attempt was made to alter the object table by
modifing existing columns. An object table cannot be altered
to modify existing columns since it is based on an object
type. The table definition must be in sync with the
corresponding type.

Action: Create a new type with the desired attribute types
and use it to create an object table. The new object table
will have the desired columns.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified

1 Answers  


ORA-02479: error while translating file name for parallel load

1 Answers  


EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


RMAN-00557: could not open MSGLOG "string"

1 Answers  


PCC-00047: Unterminated comment/string constant beginning near line number in file string

1 Answers  


ORA-01281: SCN range specified is invalid

1 Answers  


ORA-01127: database name 'string' exceeds size limit of string characters

1 Answers  


TNS-00299: Response from Navigator: string

1 Answers  


ORA-12668: Dedicated server: outbound protocol does not support proxies

1 Answers  


QSM-02115: mv references a remote object and is refreshed ON COMMIT

1 Answers  


ORA-14121: MODIFY DEFAULT ATTRIBUTES may not be combined with other operations

1 Answers  


ORA-02466: The SIZE and INITRANS options cannot be altered for HASH CLUSTERS.

1 Answers  


Categories